Hello,
In an existing workbook I have a sheet ("Main") with 7 columns of data. Column 1 contains a file number.
I generate (by a query from Access) a new workbook & sheet containing the 8 columns of data. The first 6 of which are the same as in the Main workbook. I currently use a vlookup...