+ Reply to Thread
Results 1 to 2 of 2

Change Cell Formula from master sheet

  1. #1
    Registered User
    Join Date
    02-27-2009
    Location
    saco
    MS-Off Ver
    Excel 2003
    Posts
    50

    Change Cell Formula from master sheet

    What i want is this:

    I have a workbook with 12 sheets... 1 for each month

    In this i have cells for tracking sales....

    cell Q6 has a formula of =SUM(H5:H98)+INT(SUM(I5:I98)/5)

    What i want is to have a sheet called master that if i want to change the formula to somthing like lets say =SUM(H5:H9) it will automatically change all the sheets to that in cell Q6

    Is this possible?

    I thought maybe doing this would work but nope
    Please Login or Register  to view this content.
    Last edited by DAVIDJMORIN; 05-22-2011 at 02:32 PM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Change Cell Formula from master sheet

    Hi,

    Why not select all the 12 sheets in Group mode, and then change the Q6 formula in any one of them.

    Regards

+ 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