In 'sheet one'!A1 enter formula:
='sheet 2'!BE30

HTH
--
AP

"JP" a écrit dans le message de news:
...
Novice here...

How do I carry a value found on one sheets cell over to another sheet.
So I want the value located on sheet 2 BE,30 to be carried forward to
'sheet one' at a cell location.

Effectively its a budget imp making for a project. I have different pages
showing different types of expenses,
On the front page however, I wish to have the various subtotals of all the
individual pages showing, always reflecting any changes throughout the
document.

thank you for your help
JP