I am working w/ three sheets in total, one each in three different books.
Book1.Sheet1 and Book2.Sheet2 & Book3.Sheet1. Books 1 & 2 will send data to Book3.Sheet1.
Book1.Sheet1 's data will be new records each time, and all the new records will be sent to Book3.Sheet1.
Book2.Sheet1 's data will be cumulative and only the new records should be sent to Book3.Sheet1.
Book3.Sheet1 's data records are also cumulative. So all the data from Book1.Sheet1 and Book2.Sheet1 will be appended to the exisiting records in Book3.Sheet1.
Can I store the last row value of Book2.Sheet1 somehow so the next time I append records to Book2.Sheet1 there is a value stored to reference where to begin a new data copy to Book3.Sheet1?