<<Forgot Formula>>

[Scooterdog]

I forgot the formula that allows you to "share" the information
from one cell on a page to another cell on a different page.
Thanks in advance

 

[Kevin H. Stecyk]

Scooterdog,

Sheet4, cell A5
=Sheet1!A1

Now A5 on Sheet4 references A1 on Sheet1.

If the referenced name has a space, you need to change the format slightly.
Sheet4, cell A5
='Long Name'!A1

Now A5 on Sheet4 references A1 on 'Long Name'.

Hope that helps.

Kevin