LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find cells containing exact text, and separate them Tommy Excel Worksheet Functions 3 October 6th 06 01:49 AM
multi level worksheets Lesley Excel Discussion (Misc queries) 1 September 12th 06 04:53 AM
Viewing multi worksheets Faust57 New Users to Excel 2 June 28th 06 06:05 PM
repeat rows for add'l pages for tabs on a multi-tab worksheet Nancy T. Excel Worksheet Functions 2 January 13th 06 06:35 PM
copy/paste excel to texteditor -> multi-line text cells gain unwanted double-quotes niz Excel Discussion (Misc queries) 1 October 14th 05 02:06 PM


All times are GMT +1. The time now is 08:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"