I am trying to copy the data in two columns to a new sheet in the same workbook. The size of the columns can change. One column is called "Data" and the other is called "Schedule". I will be importing the data from "Data" to "Schedule". Here is what I tried earlier for just column A, but it did not work.
FinalRow = Cells(Rows.Count, 1).End(xlUp).Row
Sheets("Data").Cells(A,FinalRow).Copy
Sheets("Schedule").Range(A2).Paste
Any suggestions? Thanks.
Bookmarks