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.
 
Back
Top