+ Reply to Thread
Results 1 to 2 of 2

Linking two cells in two workbooks

  1. 03-27-2009, 02:26 PM #1
    robertgrimsley
    robertgrimsley is offline
    Registered User
    Join Date
    03-27-2009
    Location
    Atlanta,Ga
    MS-Off Ver
    Excel 2007
    Posts
    3

    Linking two cells in two workbooks

    Hello,
    I am working with Excel 2007 and I am trying to build a spreadsheet and have encountered something I want to do and have never done. I have two separate worksheets one that is located on our server and one on my desktop. I want to be able to link a cell from one to another by using a word.
    Ex: Book 1 Table 2.07(per sq ft)
    On book 2 which is located on my desktop I want to be able to use the word Table in a column and it knows to go get the number 2.07 from book 1. The person in charge of book 1 can change that number when necessary and it changes all the books liked to it. I have figured out how to link to that cell but I want to do it through words. Can anyone help?
    Reply With QuoteRegister To Reply
  2. 03-28-2009, 03:14 AM #2
    ratcat
    ratcat is offline
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111

    Re: Linking two cells in two workbooks

    Quote Originally Posted by robertgrimsley View Post
    ........... I have figured out how to link to that cell but I want to do it through words. Can anyone help?
    G'day Robert and welcome to the forum.

    That second last sentence has thrown me out.

    But in all best interests, that could you supply an example of what your trying to achieve over 2 spreadsheets not 2 woorkbooks. Please remember the data protection law.

    Within that example, with similar layout, basically supply a before and after situations.

    Or re explain your challenge to the forum, so either I or fellow helpers can help.
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1