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?

try typing
=sheet1!o6
without the space between sheet & 1.

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


"Marshaann_82" wrote:

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?

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

"Elkar" wrote in message
...
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

"Marshaann_82" wrote:

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?

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

David Biddulph wrote:
Or just type the equals sign & then click in the cell from which you want to
pick up the data.
--
David Biddulph

"Elkar" wrote in message
...
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

"Marshaann_82" wrote:

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?

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


"Pete_UK" wrote:

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

David Biddulph wrote:
Or just type the equals sign & then click in the cell from which you want to
pick up the data.
--
David Biddulph

"Elkar" wrote in message
...
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

"Marshaann_82" wrote:

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?

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.

"David Biddulph" wrote:

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

"Elkar" wrote in message
...
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

"Marshaann_82" wrote:

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?