repeat text in same exact cells in multi worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
THANK YOU! - worked like a charm.

Peo Sjoblom said:
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
Click to expand...
 
Back
Top