MS Excel: Updating two spreadsheet simultaneously

[Sanjay Verma]

Hi Friends,
I've two spreadsheet, a & b. I would like to associate both the spreadsheets together so that when I modify the contents of a, it should automatically update the contents of b (contents may include - values / formulas etc.). Any suggestions??

[Roger Faucher · Accepted solution]

Sanjay:

Open Excel Help and search for "Overview of linked and embedded objects". See if that answers your question.

Roger

[Jorge Pinto Leite]

The b excel file should have on the cells that should be updated a link to the a file, such as:
b file, cell A1:
= a!A5*300/a!a4
Note that you should put the full path to a file, and if it includes spaces you should put it inside commas, such as:
= 'c:\my documents\a'!A5*300/'c:\my documents\a'!a4
Jorge

[Jorge Pinto Leite]

The b excel file should have on the cells that should be updated a link to the a file, such as:
b file, cell A1:
= a!A5*300/a!a4
Note that you should put the full path to a file, and if it includes spaces you should put it inside commas, such as:
= 'c:\my documents\a'!A5*300/'c:\my documents\a'!a4
Jorge

[Jorge Pinto Leite]

Sorry to answer twice, but I had problems with my internet connection...

[Jorge Pinto Leite]

Sorry to answer twice, but I had problems with my internet connection...