Sorry if this has been covered before (I imagine it has many times) but after searching for Macros I got 400 pages returned, as expected in an Excel forum. And I wasn't search of the exact search terms to use.

All I need is a macro to do the following.

F2
Ctrl + Shift + ← (left arrow)
Ctrl + X
Tab
Ctrl + V
↓ (down)
← (left)

I have tried recording the macro but keep getting all sorts of wrong results. I am just trying to get the last part of the data in e.g Cell A1 into cell A2 and then move down so I can re run the macro for cell B1.

Thanks