Hyperlink from one.xlsx cell to another two.xlxs cell & click back

  • Thread starter Thread starter Bobbi-Joe
  • Start date Start date
B

Bobbi-Joe

I want to know if it is possible to Hyperlink from one file>worksheet>cell to
another file>worksheet>cell. I am trying to link two seperate files
(workbooks) to each other, one being account's payable and the other energy
consumption. Two large files (don't want to put them together - b/c it gets
too complex)

One sheet to summarize all information that can be hyperlinked to other
Files information.
 
Hyperlinks to another workbook would open that second workbook. Is that what
you want?

I'm guessing no.

If you want to retrieve a value from a cell in that second workbook:
Open both workbooks.
Traverse to the cell that you want to retrieve
Edit|Copy (or ctrl-c)
Traverse to the receiving cell.
Edit|Paste special|paste link

Excel will adjust the formula for you when you close the sending workbook.
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
HYPERLINK Worksheet Function 3
click on one cell to locate another cell 5
Hyperlink to cell in separate workbook 3
2002 Hyperlink issues 2
Go to cell address 2
Excel Macro to hyperlink an archived worksheet to an index page 0
Hyperlink Formula Problem 2

Back
Top