I have some VBA that copies one sheet from one workbook to another. Now that I have the data in the same workbook. I have searched, but have not been able to find a solution specific to what I need. I would like to copy specific columns from Store Schedule tab to the RC Schedule tab however the columns are not the same and the column names on Store Schedule tab can be in row 2 or 3 or both. Example of some of the columns that I need to copy (maintaining the column header in the RC Schedule tab).
From Store Schedule to RC Schedule Column
1. Column A to A
2. Column C to B
3. Column D to D
4. Column E to F
5. Column HG to J
Attaching a sample of the file as well