Excel - How do I combine multiple tabs into one?

Asked By Cheeze on 12-Aug-09 12:29 PM
I have a file that has many multiple tabs with data in in each tab.  Is there
a way to combine all the Tabs into 1 sheet? Without using the Cut & Paste
option.




Jacob Skaria replied on 12-Aug-09 12:38 PM
You can using macros..Check out the article by Ron de bruin on "Copy from row
2 till the last row with data"

http://www.rondebruin.nl/copy2.htm#sheet

If this post helps click Yes
---------------
Jacob Skaria
Ashish Mathur replied on 12-Aug-09 09:48 PM
Hi,

You may get some hint from this link -
http://datapigtechnologies.com/blog/index.php/using-access-to-combine-multiple-excel-files-method-1/comment-page-1/#comment-1825

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com