Multiple Workbooks into One?


G

Guest

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
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top