Text Placement

[georgyboy]

Hi,
Working on a new book which has 5 sheets within it. The first sheet is the frontpage which holds all the info about the account. Name, address, etc.
How can I get the info from cell B8 (which is the name of the shop) into a specified cell on one of the other worksheets.
So that then on every worksheet it will say the name of the shop.

Thanks for your help

 

[earthandfire]

Assuming the first sheet is called Sheet1, then in each appropraite cell:

=Sheet1!$B$8

Hope this helps

 

[georgyboy]

thanks for the adive EaF, but couldnt get it work, the first sheet is called FrontPage but nothing happening??

 

[shetlandbob]

in the cell in question type = then change sheets and select the cell in question on the front sheet (C8). You will need to do this for each of your sheets

Robert Cumming

http://www.consultantengineer.co.uk

 

[georgyboy]

hey Bob, thanks for yous adivce, but that doesnt seem to work for text only number s, ithink.

 

[UniqueFD]

georgyboy,
Have you actually tried Bob's advice? His suggestion is sound and will work equally well for text or numbers.

E&F's solution is also excellent. I would guess that you haven't included the exclamation mark after the sheet name, if it didn't work - this is a common mistake. (ie: you should be typing "=FrontPage!$B$8"

Tony
___________________________________________________
Reckless words pierce like a sword,
but the tongue of the wise brings healing (Solomon)

 

[georgyboy]

okay thanks guys. for some reason it wouldn't work if i was pushing the enter button on my numeric pad. but will work if i push the return button on the main keyboard -??
thanks for the help i really appreciate it