Hi,

I'm trying to create a macro that takes data from one sheet of a workbook and places it in another sheet of the same workbook. The problem I'm having is that it needs accomodate varying numbers of rows.

Let's say I have 10 rows of data and I copy them over from one sheet to the destination sheet. I need to create 10 more rows underneath, 10 under that and then 10 more under that. The problem I'm having is that when I use ctrl-shift-down to go to the last row, it is recording that cell in the code. I'm not writing the code, rather recording my keystrokes.

What is the simplest way to accomplish my goal? This has to work whether it is 10 rows, 15, 100, 1000, etc.

Thanks in advance.