I have a reference number on one worksheet. I then want to search another
worksheet (Shet1) in the ssme workbook for that reference number. When found
I want to copy all the info from the other columns (B, C) into similar
columns on the new work sheet (Sheet2)
Eg
sheet 1 has the data and ColA is the ref number
ColA ColB ColC
123 date amount
Sheet2. I enter ColA data and want to then get data from Sheet1, Cols B C
ColA
123

regards Chris