I have a macro that needs to begin in the same active cell into which data was just entered. Upon exit from the cell using tab, arrow keys, or enter, the macro begins from the adjacent cell just moved into. How do I make the macro start from the original cell I was just in? Note: The macros function is to copy the original cell data from Sheet 1 and paste it into the identical coordinate cell location on Sheet 2, then return to the Selection.Address in Sheet 1.
Thank you for your help.
Thank you for your help.