Linking Text

  • Thread starter Thread starter Brenda
  • Start date Start date
B

Brenda

Is it possible to link text in Excel? I keep track of admissions and
discharges for residences and I would like to be able to link the names of
individuals from one spreadsheet to another. I keep track of number of days
in a residence, pass requests, and also when a resident is eligible for
dental work. It seems time consuming to update each of these spreadsheets
when I add or discharge a person. Any suggestions would be wonderful.
 
==Sheet2!A2 or ='Third sheet'!A3

In your destination cell, type the = sign, then go to your source sheet &
click in the source cell, then accept the formula.
 
If you want to hyperlink to the other sheet, go to Insert -> Hyperlink
(or hit Ctrl+ K) and then click on Place in this document on the left,
select the tab you want to link to and hit ok.

View help for Hyperlinks if you need more info.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Results don't macth. 2
A bit of a complicated Array that I can't figure out! HELP! 6
Excel formula - Anyone up for a challenge? 6
Need help with Date range query 1
Group on Month with multiple dates for same record 5
Daymare: 1998 0
Foreign Key Issues 2
eliminate data subset from query 2

Back
Top