Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

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

Options
  • 14-03-2013 6:28pm
    #1
    david4791
    Registered Users Posts: 373 ✭✭


    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


Comments

  • Options
    #2
    paulmclaughlin
    Closed Accounts Posts: 1,299 ✭✭✭paulmclaughlin


    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á.


  • Options
    #3
    david4791
    Registered Users Posts: 373 ✭✭david4791


    Thanks Paul


Advertisement