Excel Macro-List of Parts and Mark on another worksheet

I have a list of product #'s (Column A) on a worksheet 1. On Worksheet 2 is a large list of products of many column, but Column A is the product #.

I need:

1) On worksheet 2(large list) create a new column. ie. Insert before column A, thus product #'s is now in column B

2) Take the 1st product # from worksheet 1 A1 and loop thru column B(worksheet 2)

If found put the word "DELETE" in Column A of worksheet 2.

Go back to worksheet 1 and put in column B for that product the word "FOUND" else put the word "NOT FOUND"

3) Keep looping thru the product list on worksheet 1 until end.

4) When end,

Sort Worksheet 1 by column B("FOUND OR NOT FOUND") then by column A(product #)

Filter worksheet 2(DELETE) and sort by Product Number

The only SETUP I can think of is to be able to choose worksheet 2(as the name of this worksheet changes quite often)

That should do it, pretty straight forward I think.

Sorry everyone, but I am going to have to cancel this project. It not your faults, the starting bid price is just to much, $30.00 for such a simple project. I have picked a programmer from elance at what should the rate of $20.00.
I will try to find a bigger project to justify the higher starting price for the next one.

Skills: Excel, Visual Basic

See more: name parts mark, parts list macro excel, excel mark found column, excel macro parts, parts now, excel macro to word, parts list excel macro, excel mark, create macro in word, sort excel, mark, create excel worksheet, another back, excel macro sort, sort macro, insert macro excel, excel filter list, excel number word, word macro basic, macro else excel, number word excel, sort list, macro loop list, macro excel create word, loop excel visual basic

About the Employer:
( 36 reviews ) Riverside, United States

Project ID: #2563905

34 freelancers are bidding on average $50 for this job


Greetings....!! Please check your PMB...!!!

$30 USD in 0 days
(487 Reviews)

Yep, it's pretty straightforward, indeed. Can do. Regards, Svet.

$50 USD in 1 day
(80 Reviews)

Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet to More

$50 USD in 1 day
(61 Reviews)

hire me!!..please provide me those two we can start..Regards..Raj..!

$80 USD in 999 days
(47 Reviews)

Not a problem. I specialize in Excel work. Please see your messages. Thanks

$30 USD in 1 day
(64 Reviews)

Plz see PMB

$30 USD in 1 day
(103 Reviews)

Our team of 3 VBA developers possesses the key skills needed for this project and we can start right now. Please check your PMB.

$45 USD in 1 day
(30 Reviews)

Sir, I can do the project. Refer PMB. with regards

$38 USD in 2 days
(42 Reviews)

we do not offer package we offer Only guaranteed results..100% quality work within time limit and ...Read more in PMB

$230 USD in 7 days
(21 Reviews)

I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. I love to work with excel, always comfortable with excel. I am interested in your project and have More

$35 USD in 1 day
(37 Reviews)

I can do it well. I think it will faster we first sort the sheet for column then we need not required to check all rows. else it will be time consuming for you.

$30 USD in 1 day
(29 Reviews)

Hi, I can do it! I'm programmer for years and very familiar with VBA for excel automation. You can considered it is done. What is your excel version? Looking forwards to work with you, Cuong NH

$30 USD in 1 day
(30 Reviews)

Hi can do this. Just waiting to hear from you soon. Thanks

$30 USD in 1 day
(18 Reviews)

Hi , experiences visual basic and excel macros for more than 7 years i can help you please check my PMB

$50 USD in 2 days
(15 Reviews)

Expert Here. Please check PM..

$30 USD in 1 day
(30 Reviews)

i can develop a VBA script for your requirements.

$30 USD in 2 days
(30 Reviews)

Hi I am an Engineer and Excel professional and can do this task for you. Thanks

$30 USD in 0 days
(9 Reviews)

We r macro expert having experience over 13 years

$30 USD in 0 days
(15 Reviews)

Please see my PM

$30 USD in 2 days
(4 Reviews)

Dear cc4digital, In response to your job, I am pleased to inform you, that I finished the project, based on information which you provided. I can deliver it as soon as possible. Of course, if you would like, I can show More

$30 USD in 1 day
(1 Review)