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?
Bookmarks