Hi,

Is the following straight forward to do, as I'm having trouble getting anything to do this to work...

I have a weeks data placed on sheet A from a query against a database, this can be re-run when ever the user wants, and will probably be daily. Once the data has been placed and formatted on sheet A I want to open the achive sheet which is within another xls file.

On the archive sheet I want to place just the raw data (values) using copy and paste. The problem is if I just copy and paste the rows everytime the archive sheet will contain duplication of previous days.

The first column of the data on sheet A is the date, as is the same with the archive. I can get the last date in the archive sheet, and using this thought I would carry out a VLookup against the range of data on sheet A. Once I know which date hasn't been pasted onto the archive sheet I'd copy from that point on sheet A and paste the data onto the archive sheet, a way of appending I suppose.

The part I'm realy falling over is the VLookup from within sheet A, which contains the VBA code.

If anyone has any suggestions on the best way to do the above, or could give me an example of doing the above it'd be much, much appreciated.

Regards