Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 12th 09, 05:29 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2009
Posts: 1
Default How do I combine multiple tabs into one?

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.

  #2   Report Post  
Old August 12th 09, 05:38 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 8,521
Default How do I combine multiple tabs into one?

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


"Cheeze" wrote:

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.

  #3   Report Post  
Old August 13th 09, 02:48 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 1,766
Default How do I combine multiple tabs into one?

Hi,

You may get some hint from this link -
http://datapigtechnologies.com/blog/.../#comment-1825

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Cheeze" wrote in message
...
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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I combine data (not consolidate) from separate tabs to one? Rowema Excel Discussion (Misc queries) 2 January 16th 08 02:59 PM
Combine data in columns from 2 tabs Cong Nguyen Excel Discussion (Misc queries) 3 October 23rd 07 09:42 PM
Combine multiple workbooks into 1 workbook w/ multiple worksheets buffgirl71 Excel Discussion (Misc queries) 2 May 12th 06 10:30 PM
Combine tabs from multiple workbooks into one Alayna Excel Discussion (Misc queries) 1 September 1st 05 07:55 PM
how to combine several tabs on a spreadsheet into a summary tab w. adeeb Excel Discussion (Misc queries) 2 December 5th 04 09:49 AM


All times are GMT +1. The time now is 01:38 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017