VBA code to copy and paste a varying number of Rows

Hello,

This will be a simple issue for most of you. I have a sheet that contains data between columns A and P. I need to copy all values in these columns from A2 down (A1 being the headers that I do not want copying) and across from P2 down. Now when I have recorded the Macro I simply used Shift+Control and Down and Shift+Control and Right to highlight all cells with values and then to capture all data. However the macro has kept just those values and the next time I run it (possibly with twice as many Rows as before) it is cutting off at the previous point.

Any help?

It will be just solid data. There may be just one row of data or 35 rows. But it will be solid and no breaks in it.

Oh and there will always be at least one row of data (otherwise I do not run the report). Therefore A2 - P2 will always have data, it is just then a question of how many more rows there will be from then on.

It would actually be copied to B4 on a sheet called 'Daily Summary' and something else that has just popped into my head is that I would need it to Insert the copied cells as there is a total summary of the data in Cell B5. Therefore I will be looking to have the copied data inserted and the cells moved down on the 'Daily Summary' Sheet.

Should have really mentioned that before!!!