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.

Hi,

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

Regards