Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 93
Default Combine sheets in a workbook into one sheet?

Is this possible? I have about 100 Sheets, I need to make them into one
sheet, ideally with a new field that has the name of the sheet each record
came from, so I can export to a MysQL DB.

Any insight appreciated!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Combine sheets in a workbook into one sheet?

See
http://www.rondebruin.nl/copy2.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"msnyc07" wrote in message ...
Is this possible? I have about 100 Sheets, I need to make them into one
sheet, ideally with a new field that has the name of the sheet each record
came from, so I can export to a MysQL DB.

Any insight appreciated!

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 from multiple sheets into one sheet? David W. Owens Excel Discussion (Misc queries) 3 November 15th 08 04:50 PM
How do I combine 50 spreadsheets into 1 workbook with 50 sheets [email protected] Excel Worksheet Functions 1 October 27th 08 01:10 PM
How do I combine data from several sheets into one main sheet? Caren F Excel Worksheet Functions 0 April 19th 06 06:39 PM
combine multiple sheets, each sheet has info in different cells espo Setting up and Configuration of Excel 1 September 10th 05 01:18 PM
Combine multiple sheets into one sheet? Blueluck Excel Discussion (Misc queries) 2 June 8th 05 08:56 AM


All times are GMT +1. The time now is 07:41 PM.

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

About Us

"It's about Microsoft Excel"