I have 2 WS’s with ~200 rows of data each. WS1 is my report and WS2 is just raw data. I do not want to use V lookup; I am in need of code:

1. Look at part # in cell A4 in WS1

2. Than find that number in column A in WS2.

3. If the number is found than copy data from WS2 (let’s say) P7 to WS1 D4 and from WS2 AB7 to WS1 K4

4. Repeat the same function for all populated cells in column A in WS1.

5. If number from column A in WS1 is not found in WS2 than fill cell A in WS1 yellow.

Hopefully this makes sense. Any help would be greatly appreciated.

Thank you

John

1. Look at part # in cell A4 in WS1

2. Than find that number in column A in WS2.

3. If the number is found than copy data from WS2 (let’s say) P7 to WS1 D4 and from WS2 AB7 to WS1 K4

4. Repeat the same function for all populated cells in column A in WS1.

5. If number from column A in WS1 is not found in WS2 than fill cell A in WS1 yellow.

Hopefully this makes sense. Any help would be greatly appreciated.

Thank you

John

Last edited: