Results 1 to 2 of 2

Change Cell Formula from master sheet

Threaded View

  1. #1
    Registered User
    Join Date
    02-27-2009
    Location
    saco
    MS-Off Ver
    Google Docs
    Posts
    59

    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
    =master!q6
    Last edited by DAVIDJMORIN; 05-22-2011 at 02:32 PM.

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