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?