How do I link a cell to my work book

I have a Cell (Formulard Total)on Sheet1 of my work book, How do I link this cell (i.e. the total of the sheet figured out on Sheet1) to the other pages of my work book (So the total shows on the other pages?)

Also, can I link that cell to other workbooks? Me thinks not, but would be most grateful for some help!

Fanx

E.J the Blonde!

Posted by Ryan on June 14, 0100 8:35 AM

Hey Blonde,

The easiest thing to do is to name the cell the original information is in. To do this go to Insert -> Name -> Define when you have highlighted the cell. Put in a name that you can reference it by. Whenever you want another cell to be linked to it, just type in "=" and then the name of the cell. I.E. I have a cell named Location. On another page i want that information to show up, so in the cell i typed "=Location". And that's all she(he) wrote. Good luckRyan

(6 responses) I'm part of an organisation that is altering the way it manages a waiting list, and we have decided we want a way of picking n people per ye

Let's Connect

MrExcel.com debuted on November 21, 1998.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on this
web site are provided "as is" and we do not guarantee that they can be used in all
situations.
This site contains affiliate links. Any affiliate commissions that we
earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com
running. You can earn a commission for sales leads that you send to us by joining our
affiliate program.
View my Privacy Policy and Terms of Use.