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

I want to know if it is possible to Hyperlink from one fileworksheetcell to
another fileworksheetcell. 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.
--
Bobbi-Joe

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

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.

Bobbi-Joe wrote:

I want to know if it is possible to Hyperlink from one fileworksheetcell to
another fileworksheetcell. 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.
--
Bobbi-Joe

--

Dave Peterson