Linking Excel columns in two different excel programs

S

Shinra14

Hi,

I have a few excel programs that require the same column of information. I
would like to be able to somehow link the column in the different programs so
when I add data to the column in one program, excel automatically adds it to
the column in the other programs. When I say program, I mean spreadsheets but
these spreadsheets are apart of different excel documents or projects. Is it
possible to link the columns? Also, is it possible to have about 6 rows in
one spreadsheet to automatically display in another sheet without cut and
paste? Any help would be great.

Thank You
 
D

DNA

Launch Help in Outlook and key in this:

"Create a link to another cell, workbook, or program"
 
S

Stuart Farr

Yes, if you open the files concerned, then go to the cell you want t
populate and type "=", then click on the source file and the cell yo
want to link to and then preee <Enter>. Take out the absolute signag
if applicable and copy the cell down the column.

Close the files. Open one of the source files and change a number. Sav
and close the file. Then open the file with the formulas you earlie
established and click on Edit Links. You can then select Update value
to pull in the numbers.

Hope this help
 
Top