If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
repeat text in same exact cells in multi worksheets
I have a workbook and have 20 worksheets in the book.
example of what I would like to do. on the worksheet in the same exact numbered cells I want to put the text in once and then put a forumla to make it copy the info to 2-19 pages of the workbook. like 1 of 20 pages, 2 of 20 pages - I only want to put the "of 20 pages" once then have it when it's changed it would automatically change the other work books if I had 21 pages one time then it would change the others. I hope this makes sense. Thank you! |
#2
|
|||
|
|||
repeat text in same exact cells in multi worksheets
One way
This needs to be done once only, select the 2nd to the 20th sheet by clicking the first tab, holding down shift then click the last tab to group the sheets. Now select the cell in question in the 2nd sheet, type an equal sign, then click the 1st sheet tab and the cell where you want to link to, then press enter. Now ungroup the sheet and go to the 1st sheet and type the string and you'll see that all the other sheets are linked and will display what's in the cell of the 1st sheet -- Regards, Peo Sjoblom "Jane" wrote in message ... I have a workbook and have 20 worksheets in the book. example of what I would like to do. on the worksheet in the same exact numbered cells I want to put the text in once and then put a forumla to make it copy the info to 2-19 pages of the workbook. like 1 of 20 pages, 2 of 20 pages - I only want to put the "of 20 pages" once then have it when it's changed it would automatically change the other work books if I had 21 pages one time then it would change the others. I hope this makes sense. Thank you! |
#3
|
|||
|
|||
repeat text in same exact cells in multi worksheets
THANK YOU! - worked like a charm.
"Peo Sjoblom" wrote: One way This needs to be done once only, select the 2nd to the 20th sheet by clicking the first tab, holding down shift then click the last tab to group the sheets. Now select the cell in question in the 2nd sheet, type an equal sign, then click the 1st sheet tab and the cell where you want to link to, then press enter. Now ungroup the sheet and go to the 1st sheet and type the string and you'll see that all the other sheets are linked and will display what's in the cell of the 1st sheet -- Regards, Peo Sjoblom "Jane" wrote in message ... I have a workbook and have 20 worksheets in the book. example of what I would like to do. on the worksheet in the same exact numbered cells I want to put the text in once and then put a forumla to make it copy the info to 2-19 pages of the workbook. like 1 of 20 pages, 2 of 20 pages - I only want to put the "of 20 pages" once then have it when it's changed it would automatically change the other work books if I had 21 pages one time then it would change the others. I hope this makes sense. Thank you! |
Thread Tools | |
Display Modes | |
|
|