At 09:59 01/04/2009 -0600, 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?
There are various ways of doing this. Probably one of the easiest is
to open the different spreadsheets as necessary and to copy and paste
the cells or ranges that you want to transfer between them. You can
do this even between different spreadsheet documents.
If you use ordinary Paste, the values in your cells will be frozen as
they were at the time you complete the Paste. If you want the values
to be updated as the source values are changed, use Paste Special...
instead, and tick Link under Options in the Paste Special
dialogue. You can accept updates when you open your destination file
or you can control them individually at Edit | Links... .
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
