Find Jobs
Hire Freelancers

Data Base in a Excel with few macro assigned Command Button and an Auto Generated Mail send Features

£10-20 GBP

Abgeschlossen
Veröffentlicht vor etwa 10 Jahren

£10-20 GBP

Bezahlt bei Lieferung
Hi , I need a Data Base to be made for my project where. 1. There should be a commond button as "Input Data" which opens a user form which has got required fields - with "Date " & "Time" (which populates auto when we fill in other details in the user form and populate the Excell spread sheet) - with a" Project" drop down selection available i.e. T97K ,TXWB,T-1000,T1000 and FLEET. - with a Drop down to select "Engine ON Test" that needs picking up from the hidden sheet controlled by the super user not visible to the other [login to view URL] will be in the form of 20021/1, 20021/2, 20022/1..etc for T97K project selection , 20009/1, 20010/1..etc for TXWB ,11001/1...etc for T-1000,10001/12 ..etc for T1000 and L7/15 ..etc for FLEET. (This drop down in User form should be Project dependent and should display the Engine Respective of Project selected ex if We Select T1000 it should display 10001/12, 10001/2 etc engine for selection not the Engine put in T97K project) - with a "Module Number Affected" thats needs feeling in by Executer.(ex:S9110/1 ,B5510/2,J1000/6 ..etc) - with a "Comment" Box that needs feeling in by Executer. -Also picks up the email i.d. of the person from his or her outlook in that data base when he/she submit the details. [login to view URL] Should be Filter button in that Data base provided which filters the required fields of selection and display the output for the input Data. [login to view URL] should be a Commond Button "Engine On Test 'in the main sheet where the super user clicks to send a Auto generated mails to some default list of people (Which He will enter in the Hiddent sheet 2) as to let them know that a perticular Engine is Set On Test (This list of Engine is filled in by the Super user in the Hidden sheet) . for example [login to view URL]@xyz is in the default list so when superuser click on that commond button a mail goes to the person in his outlook stating that 20021/1 engine from T97K Project is now Set on Test.(Please provide a mail body change option in hidden sheet2 controlled by super user.) [login to view URL] drop down selection in the main sheet controlled by super user where he can select the list the engine on Test and press a other commond button named as "Engine Off Test" to send a Auto generated mail to all the person in the default list stating that the Particular Engine is Off Test and also sends a Auto Genereted mail to the Person who has raised concern putting in the details against this Engine in the first step that engine that they can not work because the engine was on test and is now Off test and also removes all the data entered against that engine in a different Sheet 3 from the main sheet which is hidden .Example :Suppose Engine 20021/1 is set on test so all the details has been filled against this engine in the Data base and after a certain period it goes off test then when we click this Engine off test Button it will send a mail to all the person who has entered data against this engine in the Data base and removes the data against this engine from main sheet to Deleted item sheet3 and also send the auto mail to the list of few defaults person mail id. kept in by sheet 2 by the super user . [login to view URL] should be password protected sheet 2 that is to be used by Superuser who controls that sheet and enter the engine on Test and some default list of email i.e. of the person he wants the information to go always when he press the Engine on test and Engine off test Button on the main sheet. 4 . There in Deleted Items sheet 3 provide a Commond button to clear the details in that sheet. Let me know if you need any more information. Thanks.
Projekt-ID: 5515204

Über das Projekt

17 Vorschläge
Remote Projekt
Aktiv vor 10 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
I have nearly 10 yrs of commercial experience within Financial services of well reputed firm around reporting using VBA and writing queries.
£13 GBP in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
17 Freelancer bieten im Durchschnitt £37 GBP für diesen Auftrag
Avatar des Nutzers
Dear I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. I have vast experience in IT / Data Entry / Web Research /Admin / SEO / Content upload for eCommerce and Marketing. Understanding how valuable an education is, I am serving Pacific Pharmaceuticals Limited as a Asstt: Manager (MIS), toward earning my Masters of Business Administration (MBA) degree and B. Sc Computer Science. I have completed many web research/data entry/ General Admin and marketing project. I am 100% able to do your project. Sincerely, Tarikul Islam
£23 GBP in 1 Tag
3,4 (22 Bewertungen)
5,1
5,1
Avatar des Nutzers
A proposal has not yet been provided
£111 GBP in 3 Tagen
4,8 (3 Bewertungen)
4,3
4,3
Avatar des Nutzers
Dear Client, I am writing in response to your job advertisement. You are looking for a Web Researcher/Data Entry/Data Mining who is efficient and got the required skills to perform the best. As an experienced incumbent I have faced lots of challenges doing this similar project. I know how to deal with this business with skilled hands with potential techniques. I am very much familiar with different tools & techniques which are required for this project. I am always looking for an immaculate output for the betterment of the project. Time is indeed a key factor for research work. I can assure you the quickest turnaround. Thanks partho
£30 GBP in 1 Tag
5,0 (1 Bewertung)
3,8
3,8
Avatar des Nutzers
Hello I have read both the project description. Your last project was cancelled so i am unable to communicate further. This time i am ready for both the projects I can do both the projects as i read the description carefully Sir, i want to talk to you as soon as possible, to start the work sooner Waiting for your reply Thank You
£20 GBP in 1 Tag
4,2 (12 Bewertungen)
3,7
3,7
Avatar des Nutzers
Hi, I am sorry you need a program or you want people work on the file you will give them. Sorry I have read the description fully but still can't understand you need the program or all this is in 1 file.I can make macro for you but need to see the database. Thanks, Yousaf
£18 GBP in 1 Tag
4,9 (24 Bewertungen)
3,1
3,1
Avatar des Nutzers
I would be pleased if you offer me this project, I have good analytical, writing, communication and interpersonal skills , with several years of experience in BPO industry
£18 GBP in 1 Tag
5,0 (1 Bewertung)
0,0
0,0
Avatar des Nutzers
See my resume that is uploaded under my profile if you are serious about this project, just to lean more about my abilities and character. Regards Maxine
£18 GBP in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
A proposal has not yet been provided
£18 GBP in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I am a confident, well mannered, highly energetic, devoted and dedicated computer science graduate who is seeking for an opportunity to serve for an organization for the development of the organization and as well as to improve my skills. I have 6 months of experience in field of software development at Mobitel (Pvt) Ltd. I'm  A dynamic self-starter with the ability and the willingness to take up challengers.  An enthusiastic team player who can interact with others to meet organizational goals.  Completed the Bsc (Hons) in Computing Science at APIIT (Asia pacific institute of information technology- Staffordshire University, UK)
£18 GBP in 10 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Hi,. Please consider my kind offer.. I would like to apply my service for this project. Feel free to check my profile and portfolio.. PM me,.
£55 GBP in 5 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
La responsabilidad y compromiso para realizar el trabajo requerido es la carta de presentación; una vez recibido el OK empezaremos a trabajar y le daremos informes de nuestros avances, trabajar en conjunto es la clave.
£23 GBP in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
A proposal has not yet been provided
£18 GBP in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
hi I am Mahmud Sarif Molla, I like this job, I can do this perfectly. I shall do well about this job........ Thank You
£18 GBP in 6 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
A proposal has not yet been provided
£32 GBP in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von UNITED KINGDOM
Derby, United Kingdom
4,8
1
Mitglied seit März 4, 2014

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.