consolidate multiple workwheets into one

[tomwhi]

Hi All,

Please can you help me! I need some VBA to help consolidate multiple worksheets into one (a 'master' worksheet). I do not have the data to hand. But I have been told every tab has identical columns but with varying number of rows. Also, please note that the data we are interested in starts a cell A15 on each tab.

I am a complete notice at VBA, and I would find it very help if you could walk me though the code.

Thank you for your help!!

Cheers Tom</SPAN>

 

[Ron de Bruin]

You can start here
Merge cells from all or some worksheets into one Master sheet

 

[Ron de Bruin]

If you not want to use VBA you can also use my Merge Add-in and select only one workbook
See : RDBMerge, Excel Merge Add-in for Excel for Windows

 

[tomwhi]

You can start here
Merge cells from all or some worksheets into one Master sheet

Hey Ron,

This is strange! I found and downloaded your add-in literally a few minutes before you replied to my thread!

Thank you - your add-in works a treat

Cheers
Tom