+ Reply to Thread
Results 1 to 3 of 3

Excel 2003 - updating multi worksheets..

Hybrid View

  1. #1
    Registered User
    Join Date
    11-23-2006
    Posts
    21

    Excel 2003 - updating multi worksheets..

    Hi Guys,
    Is there an easy way to update multiple worksheets in one go?
    To explain: -
    I have worksheets named by months (Fiscal year all in the same workbook) if I alter, say a formula, in Aprils' sheet is there an easy way to alter all the rest without using the 'Copy & Paste' method?
    Appreciate your help as always.
    Thanks

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582
    If they are in the same relative cell, you can group all the spreadsheets within the workbook by holding down the control key and clicking on whichever tabs you are interested in. Then whatever you type in the active sheet will appear in the other worksheets as well. Is this what you are looking for?

    ChemistB

  3. #3
    Registered User
    Join Date
    11-23-2006
    Posts
    21

    Thanks for solution.

    ChemistB you are an absolute diamond!
    I knew there must be a way to do it.
    I always tend to look for the most complex answer - I really must get out more.
    Many, many thanks - much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1