upobDaPlaya
asked on
How to copy data from multiple tabs to a single tab in a Vertical direction
In the attached spreadsheet I need to loop thru each tab (see SD1 and SD2 tabs) NOT called MAIN and copy over columns C and D to the Main tab starting in Col E. In the Main tab my intent is to copy the data going in a vertical direction starting at Col E of the Main tab.
In Excel VBA I know how to loop thru each of the tabs, but I am struggling with is what code I need to use to determine what the next available open column is in the Main tab before I copy the data from Tabs SD1, SD2, SD3, etc.
EE-Tab-Copies.xlsx
In Excel VBA I know how to loop thru each of the tabs, but I am struggling with is what code I need to use to determine what the next available open column is in the Main tab before I copy the data from Tabs SD1, SD2, SD3, etc.
EE-Tab-Copies.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER