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

LG G4 Note UK release date and specification rumours: Samsung Galaxy Note 5 killer could be the LG 3......

IDG UK Sites

In defence of BlackBerrys

IDG UK Sites

Why we should reserve judgement on Apple ditching Helvetica in OS X/iOS for the Apple Watch's San...

IDG UK Sites

Retina 3.3GHz iMac 27in preview: Apple cuts £400 off Retina iMac with new model