What I want to do is as follows: In shett 1 I have imformations in cells A5, B5, C5, B8, C8, E8 and so on
Now I want to move that information to row 4 - cell a1, b1, c1, d1 and so on, in sheet 2 when a push a button. The information in the cells on sheet 1 will be blanked.
Next time I move information I want it to go to Row 5 in sheet 2 (the same cells) and so on.
Is there a way to accomplish this?
I don't have much experience in Excel
Bookmarks