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

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

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