We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
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


 

Excel 2003 Auto Update


johnincrete

Likes # 0

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

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

"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

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

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

5 things we want to see in Android M: New features and fixes

IDG UK Sites

iPad mini 3 release date rumours: 'iPad mini Air' will be 30 percent thinner than current model

IDG UK Sites

Introducing generation tech

IDG UK Sites

This animated film reveals the importance of designing for everyone