I'm trying to complete something similar and most of this code is working
very well for me. I would like to know how append records copied based on
how many rows are in the spreadsheet (as it can vary depending on the office
I am appending data from). Any insight would be appreciated.

Sheets("Sheet1").Select
Range("A2:D100").Select

the code above I need to have varied based on the number of rows as it can
change



Selection.Copy
Sheets("Sheet2").Select
ActiveSheet.Paste


DebP


"Rowan Drummond" wrote:

You're welcome.

wrote:
Rowan,

Thanks! I understand the appending code. I got something similiar to
it running and it works good.

Scary thing too, I actually understood the duplicates too. I'll be
writing that one soon too.

Thanks again for all your help!
-Michael