Thank you. I appreciate your help. I am brand new to the forum and VBA in general so I am sorry again for the confusion. Thank you again for your help.
It is VBA. I apologize as I picked the wrong forum. I am trying to get a button that copies from the "Revisions" sheet, the columns of B, C, and D into the Title_Frame_Register sheet columns with the Headers, "Revision Date", "Revision Description", and "Checked By".
If the columns have data...
How can I have the code below move the Copy Destination to Columns C and D if the destination Columns A and B have data in them? And if there is data in Columns C and D, copy to E and F, and so on?
Public Sub My_Copy()
Sheets("Sheet2").Columns("A:B").Copy...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.