Copy/Paste range of data excluding certain rows and copy to another workbook

I have been working on this VBA program for a while now and I finally got it to function but a new challenge was added. As of now this program opens an excel sheet (wb1) and copies a large range of data to another excel sheet (wb2). I need it to mark the last column (T) of a row as "saved" in wb1 after it copies and then on the next run, disregard the rows that are marked "saved" in wb1. I posted this problem in another forum with no responses. http://www.ozgrid.com/forum/showthre...803#post635803.

Please Login or Register  to view this content.

Hi,

I would do this by one of below.
1. Designate a cell in wb1 to caputure the row address of saved data. Then write a routine to start copying from next row.
2. Apply some color to the last copied row and write code to start copying from a row after that color. You can clear the existing color after the macro runs and apply color to last row of newly saved data.
3. If data is wb1 and wb2 is continuous, write a code to count rows in wb2 (already saved data) and start copying from wb1 after this count.

I will pay anyone who writes the program I have described $20 (USD) via PayPal upon completion.

Upload your workbook.