I need a macro or similar to allow me to pull data from worksheet 1 to Worksheet 2 based on criteria. I have part numbers on work sheet 1 in column D, Column E is empty, but I want prices in column E. The price information is in Worksheet 2. Work Sheet 2 contains part number in column F and prices in column G. There are 10,000 populated rows in worksheet 2. There are 2200 populated rows in worksheet 1.
So, it should work like this. look at Worksheet 1,row 1 column D, value is SU1232, search work sheet 2 for value SU1232, move over one column, copy value, $2.35, return to work sheet one, and paste into row 1 Column E, continue until there is no value in work sheet 1 column D -END