Quote Originally Posted by Norie View Post
What is this line of code meant to do?
WS2.Cells(1, WS2.Columns.Count).End(xlToLeft).Column.Copy WS2.Cells(LastRow2 + 1, 1)
It appears to be copying the last column of data in WS2 to column 1 below existing data.

Could you attach a workbook with some sample data?

Perhaps that will help clarify things.
The one you quote is what doesn't work.. I expected it move the last column i just copied in to the 1st column but it does not..
I'm going to paste an example, give me a minute to access the pc i'm working on.