Copying data worksheet to worksheet

Hi,

I have a workbook with 2 sheets. Sheet 1 always overwrites the data it has with another macro. Sheet 2 (named: Data May '08 - ...) is updated with the data that sheet 1 has.

I developed a code that lets me copy the updated data contained in sheet 1 (like doing ctrl+shift+8) and paste it to sheet 2 one row after the last used one. That is, if sheet 1 has data in range A1:AP2000, I need to copy that data (ctrl+shift+8 > ctrl+c). After that, if the last row used in sheet 2 was row 1832, then I must paste the copied data from sheet 1 in row 1833.

In both sheets data begins in column A. The code seems to work, but somehow it isn't pasting all the information. By the way, paste must be a Paste Special > Values only.

Hope you can help me with the code. Thank you!

Here's the code:

Please Login or Register  to view this content.

Hi

Which column in your source data will always contain data in the last row? So if column D is the only one that will have data for every entry, then nominate that column.

rylo