Hi Walter,
I'd do that with the indirect function. Put the names of the spreadsheet that
you want to look into in cells A1, B1 and C1. In A2 enter a formula like:
=INDIRECT("'file:///E:/My Documents/"&A1&".ods'#$Sheet1."&"A1")
then fill right into B2 and C2. The path must be where your spreadsheets live.
This will give you the value of A1 in each of the three spreadsheets. You can
then copy the formula and change &"A1" to &"W20" in the formula to give you a
look at the contents of W20 in each sheet. If you want to get fancy, you can
enter the cell address you want in another cell and reference that in the
formula. For instant, put 'A1' (no quotes) in cell A3 and the formula becomes:
=INDIRECT("'file:///E:/My Documents/"&A1&".ods'#$Sheet1."&A3)
to return the same result.
tc
Walter Hildebrandt wrote:
> I have several large spreadsheets that are exactly the same except cells
> have different numbers. I would like to create a new spreadsheet to
> compare the data in just some of the cells of the original spreadsheets
>
> As a example I would like the new spreadsheet to show the numbers from the
> A1 cells of the original spreadsheets and also the numbers from the W20
> cells of the original spreadsheets.
>
> The new spreadsheet would show that Spreadsheet A had some number in cell A1
> and Spreadsheet B had some number in in cell A1 and spreadsheet C had some
> number in cell A1. Also, The new spreadsheet would show that Spreadsheet A
> had some number in cell W20 and Spreadsheet B had some number in in cell W20
> and spreadsheet C had some number in cell W20
>
> How can the above be done? Is there some way to "consolidate" just some
> cells from different spreadsheet into a new spreadsheet?.
>
_________________________________________________________________
Share photos with friends on Windows Live Messenger
http://go.microsoft.com/?linkid=9650734
