Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a workbook (called "Results.xls") where I want to consolidate multiple
worksheets from different workbooks. There can be up to 30 different workbooks that each have a single worksheet. I would like to pull all of the different worksheets into one workbook. Is it possible to do this? How would I automated it? Example: Workbook Names: Results, 90V 50Hz, 90V 60Hz, 100V 60Hz, 110V 60Hz I want to pull the worksheet out of each workbook (except for Results) and put it in the Results workbook, giving the worksheet the name of the workbook it came from. Thanks for any help. Mike |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try this Mike
http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Mike" wrote in message ... I have a workbook (called "Results.xls") where I want to consolidate multiple worksheets from different workbooks. There can be up to 30 different workbooks that each have a single worksheet. I would like to pull all of the different worksheets into one workbook. Is it possible to do this? How would I automated it? Example: Workbook Names: Results, 90V 50Hz, 90V 60Hz, 100V 60Hz, 110V 60Hz I want to pull the worksheet out of each workbook (except for Results) and put it in the Results workbook, giving the worksheet the name of the workbook it came from. Thanks for any help. Mike |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On first trial run, it appears to do exactly what I need.
Thanks, Mike "Ron de Bruin" wrote: Try this Mike http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Mike" wrote in message ... I have a workbook (called "Results.xls") where I want to consolidate multiple worksheets from different workbooks. There can be up to 30 different workbooks that each have a single worksheet. I would like to pull all of the different worksheets into one workbook. Is it possible to do this? How would I automated it? Example: Workbook Names: Results, 90V 50Hz, 90V 60Hz, 100V 60Hz, 110V 60Hz I want to pull the worksheet out of each workbook (except for Results) and put it in the Results workbook, giving the worksheet the name of the workbook it came from. Thanks for any help. Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Admin Password for multiple workbooks | Excel Discussion (Misc queries) | |||
Turning Multiple Workbooks Into a Book | Excel Discussion (Misc queries) | |||
Working on Multiple Workbooks | Excel Discussion (Misc queries) | |||
work with multiple workbooks on separate monitor for 2003 edition | Excel Worksheet Functions | |||
Matching across multiple workbooks | Excel Discussion (Misc queries) |