Could an expert provide me with VBA to do similar like:
I have a spreadsheet that has an information in Sheet1 and Sheet2. The result must go into Sheet3.
Sheet1 have info in column A (number of rows will change). In this column every cell value is unique.
Sheet2 have info in columns A to F (number of rows will change). Column A may have duplicate values.
If the value of cell A1 of Sheet1 exists in column A of Sheet2, the program will copy that entire row of Sheet2
and paste it in the first free row in the Sheet3. The program must copy every row where he found the same value.
Many thanks in advance.