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 #.
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.
34 freelancers are bidding on average $50 for this job
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.
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