HOW DUPLICATE TEXT ON ALL PAGES OF WORKSHEET FROM ONE CELL
 

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