[help with code] need to update existing code to copy and keep rows on input page

[scott micklo]

Hello all-
I have been asked to update my code that I am using to now do the following:

Read data from the tab called 2016 rejects. copy the contents into an existing page that will tabulate the totals from that specific page, AND NOW keep the original data on the input page (called 2016 Rejects).

Thanks in advance for your assistance.

I know that the .clearcontents command will need to be taken off each to leave original input data.

BUT, what code will need to be added, changed, to read the newly input data, and copy it --- NOT the data from before? I have searched and think it will be with my "FOR r= last row of old data +1" will do it. But I am not sure how to store the last line of data read so I know where to pick up with each time.

Here is the code:

Please Login or Register  to view this content.

[stnkynts]

Both your code and your post are very confusing. I recommend that you submit an example workbook with before and after expectations.

With that being said I have scaled down your code to what I think is a more manageable representation. Once you supply more information I can proceed forward.

Please Login or Register  to view this content.