Combining multiple XLS files into one

[Walt_Atwood]

Version: v.X Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Let's say I have multiple XLS spreadsheet files, each one with its own small table of data and calculations. Let's say I want to keep these original files separate.

I also want to create a new XLS file, this one combining the spreasheets from the original XLS files mentioned above. In the new consolidated file, each of the original XLS files would become a worksheet in the newly consolidated workbook.

The consolidated workbook would contain the workseets derived from the original XLS files, but the new workbook's worksheets would be simplified, with the calculations removed; I want just the results.

Is this possible with Excel v.X? How many hoops do you have to jump through? I have no significant experience with Excel; I haven't used a spreadhseet since I took a class with Lotus 1-2-3 over 15 years ago.

Thanks in advance for any feedback on this.

 

[CyberTaz]

One option:

Open the original file, select & copy the content on the sheet. In the new
file select the cell where you want the incoming content, then go to Edit>
Paste Special & select the option for "Values" or "Values & Number Formats".

Repeat for each file you want to add into the new file.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Mike Middleton]

Walt_Atwood -

How many hoops ... ? <

Only two.

... each of the original XLS files would become a worksheet in the newly consolidated workbook. <

Edit | Move or Copy Sheet | Create a copy ...

I want just the results. <

Select | Edit | Copy | Edit | Paste Special Values ...

- Mike
http://www.MikeMiddleton.com


Version: v.X Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Let's say I have multiple XLS spreadsheet files, each one with its own small table of data and calculations. Let's say I want to keep these original files separate.

I also want to create a new XLS file, this one combining the spreasheets from the original XLS files mentioned above. In the new consolidated file, each of the original XLS files would become a worksheet in the newly consolidated workbook.

The consolidated workbook would contain the workseets derived from the original XLS files, but the new workbook's worksheets would be simplified, with the calculations removed; I want just the results.

Is this possible with Excel v.X? How many hoops do you have to jump through? I have no significant experience with Excel; I haven't used a spreadhseet since I took a class with Lotus 1-2-3 over 15 years ago.

Thanks in advance for any feedback on this.