I have setup a macro so that I will move to the last cell and then copy that column of data and the column before it.
Then I move to another column and paste.
My problem: The columns will change, and when I run the marco it always copies the same 2 columns.
Is there any code that will make it dynamic and select the last row, even when it changes?
I have copied and pasted the code below: