View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jane Jane is offline
external usenet poster
 
Posts: 202
Default 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!