Moving old info in a macro

[juvleys]

Im attempting to record a macro which copies sales from one sheet onto an inventory list on the next sheet. At the start of the macro I need all the previous sales to move down one box leaving room for the new sale. Or even a macro to make sure it copies at the bottom of the list everytime, either way would be good. But whenever I try to do it with CTRL+SHIFT+ARROW DOWN+ARROW RIGHT which selects all the previous sales then maybe cut and paste or nudge down a cell, it always fails to run properly. Is there some sort of trick to doing this?

[seckert]

I have my arrow controllers set differently, so I cant be sure, but I suspect that when even though you're selecting the data using the arrows, the macro is recording the actual cell references, not the keystrokes. In order for the macro to do the "end over, end down" thing, you need to adjust the code after it has been recorded. If your data block starts in cell "A1" and you want to select the entire contiguous block, use:

    Range("A1").Select
    Range(Selection.End(xlToRight), Selection.End(xlDown)).Select

Hope this helps

SAE