How do I copy a cell from one worksheet to the others in same work

M

Marshaann_82

I know that this is a really dumb question, but i just can't get it to work.
I am trying to perform a simple function and it's been a while so i just
can't figure what I'm doing wrong. What I have is a workbook with several
sheets that are identical. I have a cell where i enter a name and I need for
that name to automatically be entered into the same cell on each of the
remaining worksheets. I thought that I could enter

=Sheet 1!O6

into the cell that I want to copy to. This is not working. What do I do?
 
E

Elkar

If there is a space in the name of the worksheet, then you'll have to enclose
the name in single quotes. For example:

='Sheet 1'!O6

HTH,
Elkar
 
D

David Biddulph

Or just type the equals sign & then click in the cell from which you want to
pick up the data.
 
P

Pete_UK

Or you could give the cell O6 in Sheet1 a name (by Insert | Name |
Define), eg your_name, and then in the other worksheets all you would
need to do is enter:

=your_name

Hope this helps.

Pete
 
M

Marshaann_82

I tried this. I thought it would work, but for some reason it isn't. Thanks
all for the advice. I haven't been able to work with that sheet today. I'll
try tomorrow to see if i can get it going.
 
M

Marshaann_82

I tried that too. i knew that it might need to be named, but no luck there
either
 
Top