Combining worksheets
 

Since I am terrible at writing macros, maybe someone here can help.
I have a folder with alot of workbooks 30+. Each one contains a single
worksheet. To make this more user friendly I would like to take each
workbook sheet and combine them into a single workbook, with the sheet
names called the filenames. Anyone that knows how I can do that
easily?
Any help is greatly appreciated!
I hope this makes sense.


--
benplace
------------------------------------------------------------------------
benplace's Profile: http://www.excelforum.com/member.php...o&userid=27446
View this thread: http://www.excelforum.com/showthread...hreadid=504623

Combining worksheets
 

Hi benplace

Try this
http://www.rondebruin.nl/copy3.htm

Use this one
http://www.rondebruin.nl/copy3.htm#sheet


--
Regards Ron de Bruin
http://www.rondebruin.nl


"benplace" wrote in message
...

Since I am terrible at writing macros, maybe someone here can help.
I have a folder with alot of workbooks 30+. Each one contains a single
worksheet. To make this more user friendly I would like to take each
workbook sheet and combine them into a single workbook, with the sheet
names called the filenames. Anyone that knows how I can do that
easily?
Any help is greatly appreciated!
I hope this makes sense.


--
benplace
------------------------------------------------------------------------
benplace's Profile: http://www.excelforum.com/member.php...o&userid=27446
View this thread: http://www.excelforum.com/showthread...hreadid=504623

Combining worksheets
 

Once again you people amaze me in here.
Thanks a million!


--
benplace
------------------------------------------------------------------------
benplace's Profile: http://www.excelforum.com/member.php...o&userid=27446
View this thread: http://www.excelforum.com/showthread...hreadid=504623