Hi Bobbie-Joe,

If you are talking about making a hyperlink in a cell so it will open
another worksheet, you can select a cell and right click, select
"Hyperlink..." then select "Existing File or Web Page" in the left-hand pane.
Navigate to your other spreadsheet.

If you are looking for the contents of the cell in the second spreadsheet to
display in the cell in the first spreasheet put this in the cell in the first
spreadsheet:

='[anotherfile.xlsx]sheet1'!A1

Replace Sheet1 and the cell reference with your sheet and cell.

An easy way to determine what to put in the cell is to open both
spreadsheets. In the first spreadsheet select a cell and then select the
AUTOSUM function, then select the cell on the 2nd spreadsheet and hit enter.
It will display the path in the formula on the first spreadsheet so just
remove the word "SUM" from the formula.

Let me know if this is right for you.

Squeaky

"Bobbi-Joe" wrote:

I am looking to connect one file 'seperatefile.xlsx' to another cell in
another file 'anotherfile.xlsx' with seperate worksheets. Is this possible?

Connect one cell to another cell from two seperate files with 5 worksheets
each.
--
Bobbi-Joe