Link to home
Start Free TrialLog in
Avatar of MrBrownUK
MrBrownUK

asked on

Compiling Two Worksheets in Excel into One and export as CSV

I have a excel reporting tool which generates two sheets, both with equal amount of columns.

My task is to create a third worksheet which is the two sheets combined into one in the following format.


(Sheet 3)
---------------

Sheet 1 (Title)
Name1  Name2  Name3
Data1    Data2     Data3

Sheet 2 (Title)
Name1  Name2  Name3
Data1    Data2     Data3 

Open in new window


I need to have this automated in VBA, any direction would be grateful.
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

for sure it can be done to make it more freindly to you could you post the 2 worksheet ?
gowflow
SOLUTION
Avatar of Markus Fischer
Markus Fischer
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MrBrownUK
MrBrownUK

ASKER

Excellent, that was really helpfull
your welcome
gowflow