<<Forgot Formula>>

  • Thread starter Thread starter Scooterdog
  • Start date Start date
S

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
 
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
 
Back
Top