In Progress

Excel Macro

I need to create a macro in Excel that will do the following:

1. Open a new file with several worksheets (between 4 and 10)

2. Accept "Last Name" and "First Name" inputs

3. Populate one column with "Last Name" input, and the adjacent column with "First Name" input

4. Access a database and obtain an ID number for the corresponding "Last Name" and "First Name" inputs, and populate a column with the ID number

5. Produce an alert if the same Last Name, First Name and ID combination appear in more than one worksheet of the file

Skills: Excel

See more: macro, macro excel, macro + excel, create excel worksheet, excel macro combination, excel inputs, excel macro populate worksheet, file name excel, excel macro access, combination macro excel, macro excel database, excel macro open file, excel create macro, excel database input, excel populate worksheet worksheet, excel create access database, populate excel excel file, excel combination, need macro excel, alert database, create access database excel, worksheet excel, number excel macro, excel database macro, column excel

About the Employer:
( 15 reviews ) Oro Valley, United States

Project ID: #1257207

Awarded to:

koolsidz

Excel Whiz here :) Please see pmb for more details :)

$35 USD in 0 days
(104 Reviews)
5.8

33 freelancers are bidding on average $47 for this job

nagybatonyi

In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are inclu More

$35 USD in 1 day
(48 Reviews)
5.6
vbexcel

Excel / VBA expert - ten years experience.

$40 USD in 0 days
(27 Reviews)
5.4
Krusche

Hello. We are a German Company with already working solution. Please check your PMB for details.

$180 USD in 1 day
(21 Reviews)
5.2
gshiels

I have 20 years Excel experience and strong VBA skills, so I'm sure that I can help you with this project.

$150 USD in 2 days
(11 Reviews)
5.1
MDavidCrompton

Hello, This was more difficult than it sounded but I have done it, just for fun. See example attached to PM. Please also check out my Feedback. David

$30 USD in 1 day
(22 Reviews)
4.9
vgrichards

Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement.

$30 USD in 1 day
(25 Reviews)
4.0
shacoim

***Plz check PM***

$30 USD in 0 days
(10 Reviews)
3.9
nblsoft

Hello sir I've viewd your project and I am interested and offer you my services. I have more than 12+ years with Microsoft Excel. I can do anything with it. Looking Forward

$45 USD in 1 day
(2 Reviews)
2.7
FirestarterXIII

I'm Excel and VBA programming expert. It'll take few hours.

$30 USD in 1 day
(1 Review)
2.4
thilinapr

Hi, This is very straightforward and I would love to complete this for you. Have sent details in PM. Please let me know if you need additional information. Thanks!

$40 USD in 1 day
(3 Reviews)
2.3
prabhabusiness

Hi, Please check PMB

$30 USD in 1 day
(1 Review)
1.0
utsatsral

this project easy and interesting....... i can do it................

$40 USD in 2 days
(0 Reviews)
0.0
nazim2004bd

I am new at freelance. I understood this project. i have done couple of job as like this. i have huge experience in this side. my typing speed is around 60+/min. i can assure you that i will deliver this work on time

$30 USD in 1 day
(0 Reviews)
0.0
vgj

I understand your requirement and I am very much interested to complete the task for you. I am a VBA professional and can finish this task soon and open to any alteration and suggestions that you would like to make.

$30 USD in 2 days
(0 Reviews)
0.0
xidryck

Hi, I'm interested in helping you on this project. Send me the details and I will make the macro and send it back to you. You can pay me after you got what you need.

$50 USD in 2 days
(0 Reviews)
0.0
exceluser

I am happy to complete this project for you. See my profile for my qualifications in Excel. Any questions, please feel free to ask or send me a PMB.

$30 USD in 1 day
(0 Reviews)
0.0
Inbasekaran

Hi I am expert in excel and i have experiance in macro so i can able to do this job

$30 USD in 5 days
(0 Reviews)
0.0
QAEngineer001

I have experience in database and macros. This requirement what you have given seems to be very easy. I can do this. Thanks.

$30 USD in 4 days
(0 Reviews)
0.0
gvarunachalam

Hi, I m having Microsoft Office Specialist Certification. I have a strong knowledge in Excel, VBA Macros. Its a very simple project and I can do it within one day in MS-Access or SQL. Kindly give me a chance. I m the n More

$30 USD in 1 day
(0 Reviews)
0.0
todsnewlife

I can tackle this project for you. I have over ten years of experience developing and maintaining automated Excel reporting solutions to meet the business needs of various clients. I am very familiar with this kind of More

$100 USD in 14 days
(0 Reviews)
0.0