Parsing Multiple sheets into one

tardmonkey · Apr 9th, 2002, 11:18 AM

Hello, I was curious if there is a way , i can take a workbook containing multiple sheets, and parse them into one single file. Really doesnt matter the format of the file, i can do another conversion on that. The reason I ask is, I have a workbook , with like 600 seperate pages in it. And it needs to be reduced to one output file, for importing into a DB.

Any help would be greatly appreciated

Al Chara · Apr 9th, 2002, 11:21 AM

Download asap at:
http://asap-utilities.com/
It has a lot of useful utilities including what you want.

tardmonkey · Apr 9th, 2002, 11:32 AM

thanks for the speedy reply, bu tno unfortunately , it doesnt support exporting more then one sheet into a single file. =

tardmonkey · Apr 9th, 2002, 11:53 AM

anyone else have any ideas???., heh

Al Chara · Apr 9th, 2002, 12:16 PM

Sure it does.

Goto ASAP Utilities|Sheets|Summarize rows or columns from several sheets|follow the instructions

tardmonkey · Apr 9th, 2002, 12:51 PM

You have helped me tremendously!!!!! words cannot express thanks.

Thank You again!!!

Apr 9th, 2002, 11:21 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Download asap at: http://asap-utilities.com/ It has a lot of useful utilities including what you want. __________________ Kind regards, Al Chara

Apr 9th, 2002, 12:16 PM	#5
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Sure it does. Goto ASAP Utilities\|Sheets\|Summarize rows or columns from several sheets\|follow the instructions __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 11:18 AM	#1
tardmonkey New Member Join Date: Apr 2002 Posts: 4	Hello, I was curious if there is a way , i can take a workbook containing multiple sheets, and parse them into one single file. Really doesnt matter the format of the file, i can do another conversion on that. The reason I ask is, I have a workbook , with like 600 seperate pages in it. And it needs to be reduced to one output file, for importing into a DB. Any help would be greatly appreciated

Apr 9th, 2002, 11:32 AM	#3
tardmonkey New Member Join Date: Apr 2002 Posts: 4	thanks for the speedy reply, bu tno unfortunately , it doesnt support exporting more then one sheet into a single file. =

Apr 9th, 2002, 11:53 AM	#4
tardmonkey New Member Join Date: Apr 2002 Posts: 4	anyone else have any ideas???., heh

Apr 9th, 2002, 12:51 PM	#6
tardmonkey New Member Join Date: Apr 2002 Posts: 4	You have helped me tremendously!!!!! words cannot express thanks. Thank You again!!!