HYPERLINKS

B

BG

I have an excel workbook with 3 work sheets. I want to hyperlink a cell in
one worksheet to a cell in another worksheet. How do I do this?
 
F

FloMM2

BG,
What you need to do is Link them.
The easiest way I have found, and make the fewest errors typing is as follows:
Open both worksheets and resize them to fit side by side on your screen.
Say the cell in worksheet1, cell a16 has the value you want in worksheet2,
cell b45.
On worksheet2 in cell b45 select it and type "=" without "".
Then select worksheet1 cell a16, by just selecting the cell.
What you should see in the cell b45 is something like "=worksheet!1$A$16"
without the "".
hth
 

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

Top