Could an expert provide me with VBA that will do the following:
Look up contents of cell A2 [sheet 1] in Sheet 2. column J
if it finds it in sheet 2 copy the entire rows into Sheet 3 [there could be just one row or many to copy]
So lets say in A2 in Sheet 1 we have CHF-38649188-LOH
look this up in Sheet 2 in column J
now lets say J10, J11,J12 all have ref CHF-38649188-LOH copy rows J10,J11J12 to Sheet3.
Continue doing this for all items in Sheet 1 column A