Contact Forum Editor

Send an email to our Forum Editor:

PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom

It's free to register, to post a question or to start / join a discussion

View Forum Rules | Contact Forum Editor

 

Excel 2003 Auto Update

johnincrete

Likes # 0

Posted September 29, 2011 at 4:52PM

This is linked to other post about printing.

If I create subsidiary spreadsheets by copy/paste selected columns, is there any way to automatically update the relevent cells in the subsidiary spreadsheets if the corresponding cell in the master sheet is changed?

In the same way, if a row is deleted, can the corresponding row in the subsidiary sheets be automatically deleted. Similarly, if a row is added in the master sheet, can it be automatically added to all subsidiaries

Like this post
mgmcc

Likes # 0

Posted September 29, 2011 at 7:51PM

Yes. You don't Copy/Paste the data from the Master sheet to the Subsidiary sheet, you Link the data.

With both sheets open, click a cell in the Subsidiary sheet and type = then go to the cell in the Master sheet that it needs to link to and press Enter. Now any changes to the cell in the Master sheet will update automatically in the Subsidiary sheet. If the Master sheet isn't open when you launch the Subsidiary sheet, you will be prompted to Update the linked cells, which can be done without opening the Master sheet.

Like this post
mgmcc

Likes # 0

Posted September 29, 2011 at 7:57PM

"Similarly, if a row is added in the master sheet, can it be automatically added to all subsidiaries"

Not aware of a simple way to do that because the Link won't exist in the subsidiary sheet. It may be possible but is beyond my mediocre knowledge! A macro or some programming might be required.

Like this post
johnincrete

Likes # 0

Posted September 30, 2011 at 3:14PM

Thanks mgmcc. I am wondering if its the best way to go

Like this post

Reply to this topic

This thread has been locked.



Check out PC Advisor's other tech forums

Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story. Both your name and the recipient's name and address will not be used for any other purpose.