This seems like it should be easy, but I am having a brain freeze;
I'm trying to make a macro that copy and pastes certain values to one particular cell. However I want the macro to function that whenever I run it it will select the row directly underneath the last row.
I.e., I want to run the macro and it to copy cell A1 and place the info into cell B1, then for a second time I would like to push the button and for it to copy cell A2 and paste it in cell B1, then for a third time I want to push the button and it will copy cell A3 and paste into cell B1 and so on. Once it hits my last dedicated cell (e.g., A5) I would like for it to start over at A1, each time replacing cell B1 with the copied info from those cells. Thanks in advance..
Bookmarks