WORKSHEETS
 

I did this before; however, I have not utilized it for so long I forget how
to do it.

I want a particular cell's content (in the first worksheet) to be displayed
in other different locations in multiple worksheets.

First worksheet in cell A:1 contains '12 JAN 09'

I want to be able to take what is displayed in A:1 and display it in any
other worksheet and in various locations on those worksheets. Then, when
cell A:1 is changed / edited / modified, the other cells in the other
worksheets will reflect the new information too.

I am not sure if it was PLUS or what to do this. I can't find PLUS anywhere
in Help so that might not be it. Of course, I may have been in a different
version of Excel too. Like I said, I know I did it, but I forget what I did
to make it work.

Any help would be appreciated. Thank you.

WORKSHEETS
 

Hi
If you put this formula: =Sheet1!A1, anywhere in other worksheets, it
will give you exactly what you want. Sheet1 is the original name of the Tab,
change it to your if they've been changed.
HTH
John
"Boyertown Casket" wrote in
message ...
I did this before; however, I have not utilized it for so long I forget
how
to do it.

I want a particular cell's content (in the first worksheet) to be
displayed
in other different locations in multiple worksheets.

First worksheet in cell A:1 contains '12 JAN 09'

I want to be able to take what is displayed in A:1 and display it in any
other worksheet and in various locations on those worksheets. Then, when
cell A:1 is changed / edited / modified, the other cells in the other
worksheets will reflect the new information too.

I am not sure if it was PLUS or what to do this. I can't find PLUS
anywhere
in Help so that might not be it. Of course, I may have been in a
different
version of Excel too. Like I said, I know I did it, but I forget what I
did
to make it work.

Any help would be appreciated. Thank you.

WORKSHEETS
 

John, Sorry for not responding immediately, I had some personal matters to
resolve.

The first worksheet (tab) in my workbook is PPTS<space2009 while the cell I
want to copy to other worksheets is E1. According to what you mentioned
below, I placed this formula in the first cell of another worksheet (tab)
where I wanted the information to appear: =PPTS<space2009!E1

It does not work. Perhaps I am doing something incorrect.

"John" wrote:

Hi
If you put this formula: =Sheet1!A1, anywhere in other worksheets, it
will give you exactly what you want. Sheet1 is the original name of the Tab,
change it to your if they've been changed.
HTH
John

WORKSHEETS
 

Hi
You need to do it this way ='PPTS 2009'!E1 if you have space between words
you need to brace them with Apostrophe as per sample.
Not sure in english if its call apostrophe, english is my second language.
HTH
John
"Boyertown Casket" wrote in
message ...
John, Sorry for not responding immediately, I had some personal matters to
resolve.

The first worksheet (tab) in my workbook is PPTS<space2009 while the cell
I
want to copy to other worksheets is E1. According to what you mentioned
below, I placed this formula in the first cell of another worksheet (tab)
where I wanted the information to appear: =PPTS<space2009!E1

It does not work. Perhaps I am doing something incorrect.

"John" wrote:

Hi
If you put this formula: =Sheet1!A1, anywhere in other worksheets, it
will give you exactly what you want. Sheet1 is the original name of the
Tab,
change it to your if they've been changed.
HTH
John

WORKSHEETS
 

Hi Again
A simple way of doing it is starting from the cell E1 type = then press on
the Tab PPTS 2009 and click on the cell you want and press enter.
Voila your formula is done.
HTH
John
"Boyertown Casket" wrote in
message ...
John, Sorry for not responding immediately, I had some personal matters to
resolve.

The first worksheet (tab) in my workbook is PPTS<space2009 while the cell
I
want to copy to other worksheets is E1. According to what you mentioned
below, I placed this formula in the first cell of another worksheet (tab)
where I wanted the information to appear: =PPTS<space2009!E1

It does not work. Perhaps I am doing something incorrect.

"John" wrote:

Hi
If you put this formula: =Sheet1!A1, anywhere in other worksheets, it
will give you exactly what you want. Sheet1 is the original name of the
Tab,
change it to your if they've been changed.
HTH
John

WORKSHEETS
 

John,

I did it the way you suggested in both of your last postings and the only
thing that appears in the cell in which I want the info from the first
worksheet to appear is the formula itself. The data does not appear from the
worksheet as intended.

Is there a formatting issue with the 'copy to' worksheet(s) cell(s)?

I just don't know why it is not working.

Jerry

"John" wrote:

Hi
You need to do it this way ='PPTS 2009'!E1 if you have space between words
you need to brace them with Apostrophe as per sample.
Not sure in english if its call apostrophe, english is my second language.
HTH
John

WORKSHEETS
 

Ding Ding - Perhaps this is the problem. The data in cell E1 on worksheet
PPTS<space2009 has a single column width of 12. The place where I want to
copy this information to is the result of two merged cells which together
total 12. In other words, cell b1 may be 8.57 and cell b2 may be 3.43 but
when I merged the two cells, they total 12. Could this be why it is not
working? If that is the problem, is there a work-around?

I have been totally bewildered about this and then I took another look at
the column widths. That is the only thing I can think of to prevent it from
working.

To test this theory, I copied what I wanted to another worksheet where the
single (unmerged) column was the same size as the original. It worked. So,
is there a work-around?

Thanks.

"John" wrote:

Hi
You need to do it this way ='PPTS 2009'!E1 if you have space between words
you need to brace them with Apostrophe as per sample.
Not sure in english if its call apostrophe, english is my second language.
HTH
John
"Boyertown Casket" wrote in
message ...
John, Sorry for not responding immediately, I had some personal matters to
resolve.

The first worksheet (tab) in my workbook is PPTS<space2009 while the cell
I
want to copy to other worksheets is E1. According to what you mentioned
below, I placed this formula in the first cell of another worksheet (tab)
where I wanted the information to appear: =PPTS<space2009!E1

It does not work. Perhaps I am doing something incorrect.

"John" wrote:

Hi
If you put this formula: =Sheet1!A1, anywhere in other worksheets, it
will give you exactly what you want. Sheet1 is the original name of the
Tab,
change it to your if they've been changed.
HTH
John

WORKSHEETS
 

Hi
Merged cells are often the cause of problems but I don't thing it is now.
Remove the formula by deleting it, use the delete botton not spacebar, then
format cell as : General, back retype your formula. I tried it with merged
cells and no problem.
HTH
John
"Boyertown Casket" wrote in
message ...
Ding Ding - Perhaps this is the problem. The data in cell E1 on worksheet
PPTS<space2009 has a single column width of 12. The place where I want
to
copy this information to is the result of two merged cells which together
total 12. In other words, cell b1 may be 8.57 and cell b2 may be 3.43 but
when I merged the two cells, they total 12. Could this be why it is not
working? If that is the problem, is there a work-around?

I have been totally bewildered about this and then I took another look at
the column widths. That is the only thing I can think of to prevent it
from
working.

To test this theory, I copied what I wanted to another worksheet where the
single (unmerged) column was the same size as the original. It worked.
So,
is there a work-around?

Thanks.

"John" wrote:

Hi
You need to do it this way ='PPTS 2009'!E1 if you have space between
words
you need to brace them with Apostrophe as per sample.
Not sure in english if its call apostrophe, english is my second
language.
HTH
John
"Boyertown Casket" wrote in
message ...
John, Sorry for not responding immediately, I had some personal matters
to
resolve.

The first worksheet (tab) in my workbook is PPTS<space2009 while the
cell
I
want to copy to other worksheets is E1. According to what you
mentioned
below, I placed this formula in the first cell of another worksheet
(tab)
where I wanted the information to appear: =PPTS<space2009!E1

It does not work. Perhaps I am doing something incorrect.

"John" wrote:

Hi
If you put this formula: =Sheet1!A1, anywhere in other worksheets,
it
will give you exactly what you want. Sheet1 is the original name of
the
Tab,
change it to your if they've been changed.
HTH
John