View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
benplace
 
Posts: n/a
Default 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