I have a xcl spreadsheet which has two worksheets (Sheet1 and Sheet2).
Sheet1 has three columns (A, B, C).
Sheet2 has 6 columns (A,B,C,D,E,F).
What I am trying to achieve is as follows
If Sheet1!A2 matches the contents of a cell in Sheet 2 column A then copy the values from Sheet2...