Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
How to print a worksheet but number the pages by workbook | Excel Discussion (Misc queries) |