HOW DUPLICATE TEXT ON ALL PAGES OF WORKSHEET FROM ONE CELL

Well, you can enter it into, for instance, cell A1 of sheet1 and then in
other sheets, type =Sheet1!A1, or you can put it in sheet1, select it, and
Insert-->Name-->Define and call it CoName. Then in other sheets, put
=CoName. Or you can just hold the shift key and select all the sheets you
want it on, click on the cell and type it in, then remember to ungroup the
sheets... many options for you, Sam.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Samantha Stevenson" <Samantha [email protected]> wrote in
message news:[email protected]...
> I would like to enter text [title, client etc] on the cover page of my
> document, and have the information copy to corresponding cells on all the
> attached worksheets. Which function will allow me to do that?

Anne, Thank you so much! You are a lifesaver.
All the best,
Samantha

"Anne Troy" wrote:

> Well, you can enter it into, for instance, cell A1 of sheet1 and then in
> other sheets, type =Sheet1!A1, or you can put it in sheet1, select it, and
> Insert-->Name-->Define and call it CoName. Then in other sheets, put
> =CoName. Or you can just hold the shift key and select all the sheets you
> want it on, click on the cell and type it in, then remember to ungroup the
> sheets... many options for you, Sam.
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "Samantha Stevenson" <Samantha [email protected]> wrote in
> message news:[email protected]...
> > I would like to enter text [title, client etc] on the cover page of my
> > document, and have the information copy to corresponding cells on all the
> > attached worksheets. Which function will allow me to do that?
>
>
>

Well, you can enter it into, for instance, cell A1 of sheet1 and then in
other sheets, type =Sheet1!A1, or you can put it in sheet1, select it, and
Insert-->Name-->Define and call it CoName. Then in other sheets, put
=CoName. Or you can just hold the shift key and select all the sheets you
want it on, click on the cell and type it in, then remember to ungroup the
sheets... many options for you, Sam.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Samantha Stevenson" <Samantha [email protected]> wrote in
message news:[email protected]...
> I would like to enter text [title, client etc] on the cover page of my
> document, and have the information copy to corresponding cells on all the
> attached worksheets. Which function will allow me to do that?

Anne, Thank you so much! You are a lifesaver.
All the best,
Samantha

"Anne Troy" wrote:

> Well, you can enter it into, for instance, cell A1 of sheet1 and then in
> other sheets, type =Sheet1!A1, or you can put it in sheet1, select it, and
> Insert-->Name-->Define and call it CoName. Then in other sheets, put
> =CoName. Or you can just hold the shift key and select all the sheets you
> want it on, click on the cell and type it in, then remember to ungroup the
> sheets... many options for you, Sam.
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "Samantha Stevenson" <Samantha [email protected]> wrote in
> message news:[email protected]...
> > I would like to enter text [title, client etc] on the cover page of my
> > document, and have the information copy to corresponding cells on all the
> > attached worksheets. Which function will allow me to do that?
>
>
>

I would like to enter text [title, client etc] on the cover page of my
document, and have the information copy to corresponding cells on all the
attached worksheets. Which function will allow me to do that?

Well, you can enter it into, for instance, cell A1 of sheet1 and then in
other sheets, type =Sheet1!A1, or you can put it in sheet1, select it, and
Insert-->Name-->Define and call it CoName. Then in other sheets, put
=CoName. Or you can just hold the shift key and select all the sheets you
want it on, click on the cell and type it in, then remember to ungroup the
sheets... many options for you, Sam.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Samantha Stevenson" <Samantha [email protected]> wrote in
message news:[email protected]...
> I would like to enter text [title, client etc] on the cover page of my
> document, and have the information copy to corresponding cells on all the
> attached worksheets. Which function will allow me to do that?

Anne, Thank you so much! You are a lifesaver.
All the best,
Samantha

"Anne Troy" wrote:

> Well, you can enter it into, for instance, cell A1 of sheet1 and then in
> other sheets, type =Sheet1!A1, or you can put it in sheet1, select it, and
> Insert-->Name-->Define and call it CoName. Then in other sheets, put
> =CoName. Or you can just hold the shift key and select all the sheets you
> want it on, click on the cell and type it in, then remember to ungroup the
> sheets... many options for you, Sam.
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "Samantha Stevenson" <Samantha [email protected]> wrote in
> message news:[email protected]...
> > I would like to enter text [title, client etc] on the cover page of my
> > document, and have the information copy to corresponding cells on all the
> > attached worksheets. Which function will allow me to do that?
>
>
>