Use Toolbox To Merge Table.click Toolbox On The Top Bar.

Open workbook which contains multipule worksheets which ready to be merged.mine contains three sheets with same title row. Most examples of this i've been able to find involve creating a new master worksheet. Create master list from several worksheets of data.

Select Col1, Col4, Col6 .

Instead, i'd like to have a permanent master list that doesn't get deleted. I've tried modifying some code i've found on my own and it works, except it duplicates the data when it copies to the master list. So using select col1, col2, col3, col4, col5, col6 would mean the same as select * .

The Order By Clause In The Above Example.

Okay, moving on to another explanation. Select worksheets needed to be merged. If you have more sheets, just add them to the bottom of the list in column f and copy the formula in g and h down as required.

So If You Had A Situation Where You Only Wanted To Output Col1, Col4 And Col6 Then You Would Have The Following:

If you have more data, just copy the formulae in a:c down as required. By rajsa in forum excel programming / vba / macros replies: