Peo + Julie Many thanks for your answer with the last query.

I Have a similar question, please advise:
This method [INDIRECT()] does work with values form a different spreadsheet.

I type the link (as text) from a different spreadsheet in a cell in the
current spreadsheet and use this method to call a value in a cell.

Would appreciate a detailed answer (if complicated) - I'm a novice user!

Many thanks in advance.