How do I link workbooks in MS Excel 2013/2010?

david4791 · 2013-03-14 17:28:57

How do I link workbooks in MS Excel 2013/2010? I wish to draft several reports in the excel workbooks, they will have common figures in some cells. I want to amend figures in one book which will then automatically amend Any advice would be great Dave

14-03-2013 06:28PM

#1

david4791

Registered Users, Registered Users 2 Posts: 373 ✭✭

Join Date: July 2008

Posts: 246

How do I link workbooks in MS Excel 2013/2010?
I wish to draft several reports in the excel workbooks, they will have common figures in some cells. I want to amend figures in one book which will then automatically amend
Any advice would be great

Dave

0

Comments

#2 14-03-2013 06:35PM

paulmclaughlin

Closed Accounts Posts: 1,299 ✭✭✭

Join Date: March 2011

Posts: 1127

Not too sure about 2013, but if have one sheet open click into one box you wish to be the same as another. Type "=(" without quotes then click the box you want it to be the same as and the formula should change to be "=(D14)" or whatever. Whenever sheet 1 is opened you'll be asked do you want to automagically update them. Voilá.

0
#3 15-03-2013 07:07AM

david4791

Registered Users, Registered Users 2 Posts: 373 ✭✭

Join Date: July 2008

Posts: 246

Thanks Paul

0