Hi

I need to copy data between xls files. File One is a data entry file. I
need to open File Two, look down column A to the last used reference no, add
one this and insert it in the cell below. Then I need to copy specific cells
from File One into cells on this row into columns B, C, D, E & F.

Being a relative novice, any help will be assisted.