How do I combine multiple tabs into one?

[Cheeze]

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]

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

 

[Ashish Mathur]

Hi,

You may get some hint from this link -
http://datapigtechnologies.com/blog...l-files-method-1/comment-page-1/#comment-1825

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com