I have a set of worksheets with different column headings. I want to merge all these worksheets into a single one with all the columns present from all the worksheets.
For example:
In Worksheet.1:
Col1,Col2,Col3
In Worksheet.2:
Col1,Col2,Col4
In Worksheet.3:
Col1,Col2,Col5
In Merged Worksheet, columns should be like:
Col1, Col2, Col3, Col4, Col5.
This is what i need to acheive through Macro in Excel2007.
Please post your comments/suggestions.
Thank you.
Bookmarks