I have a set of code working but it can only copy a column at a time, as shown below:
x = Range("A" & Rows.Count).End(xlUp).Row
x = x + 1
Sheets("CSV").Range("B" & x).Copy
Application.CutCopyMode = False
So i was wondering if the...