I want to be able to copy the value in L4 and paste it in any given cell in Column C.
Right now the macros only copies the value and L4, but it can't paste (special) it in the corresponding cell in Column C without changing the active cell. I want to be able to automatically paste it into the cell in Column C after the value in L4 is copied.
The cell will be different in Column C each time I run the macro.
Does this make any sense?
Bookmarks