| View previous topic :: View next topic |
| Author |
Message |
pennnnny
Newbie
Joined: 01 Oct 2010
Posts: 2
|
 Posted: Fri Oct 01, 2010 5:53 am Post subject: [SOLVED] trouble with copying text from sheet1 to sheet2.... |
 |
|
Hi there,
I am creating a staff roster for a work place and I have 2 sheets - one sheet is the actual roster, while the second sheet is the 'weekly forecast' which calculates wages spent, approximate takings etc. On sheet 1 I have cell A5 as a text cell with the name "Jeff" in it, in sheet 2 I want to have cell A5 automatically show up as "Jeff" - so if I change the employee "Jeff" in sheet 1, it will automatically change in sheet 2.
I have tried just doing =Sheet1.A5 and formatting the cell to 'text' but it doesn't work - arrrgh.
I am stuck on this and it seems so simple.....
Any help? I would greatly, greatly appreciate it!!
Last edited by pennnnny on Fri Oct 01, 2010 5:47 pm; edited 2 times in total |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8983
Location: Lexinton, Kentucky, USA
|
| Posted: Fri Oct 01, 2010 7:27 am Post subject: |
|
|
=Sheet1.A5 works fine for me. I didn't format either cell as text.
Don't put your email address in a post - spammers troll for them. |
|
| Back to top |
|
|
pennnnny
Newbie
Joined: 01 Oct 2010
Posts: 2
|
| Posted: Fri Oct 01, 2010 5:48 pm Post subject: |
|
|
all good ... thanks for the heads up on the email address thing
someone on another forum told me to remove all formatting and it should work, and it does! |
|
| Back to top |
|
|
|
