# Changing Formulas from Another Worksheet.

##### New Member
Well, I hope I can explain this clearly. I have formulas in a worksheet such as (=Average(E7, F7, G7, H7, AQ7)*0.6, which the cell reference is (I7) the formula gives a 60% value of the total. Now in another worksheet I want to change this formuls value from 60% to maybe 50% so all I want to do is type 0.5 an it will change the value of the formula on that worksheet. Ther are 30 formulas that will be effected such as: (I7, then I8, etc. The same applies the the formuls (E7 Etc. become E8 Etc. and so on forthe total of 30 forumlas.
Can anyone or does any know how to do this type of function. Thanks

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

#### sbeatton

##### Active Member
Can you do a simple find & replace?

#### mikerickson

##### MrExcel MVP
You could use a named value
Name: PercentOfTotal
Value: .5

and add "*PercentOfTotal" to all the formulas on the sheet.

Change the named value at will (or set it to a cell address or...)

or are you asking for the technique to change all the formulas on a worksheet? If so Find = , ReplaceWith =PercentOfTotal*

Last edited:

##### New Member
OK PercentOfTotal - Please show an example:
Worksheet name is: Grade Book English
Formula is: =average(E7,F7,G7,H7,Aq7)*0.6
Cell: I7

The new worksheet to change the percent of the value of 0.6:
SetUp Values
Cell: Any

Now I presume you mean this: =PercentOfToal(='Grade Book English'!(I7) then in this cell where the formula is just enter 0.5 or 0.4 and it will change the reference cell value in that worksheet. Correct or wrong. Thanks

#### mikerickson

##### MrExcel MVP
Create the name PercentOfTotal as described above.
Activate the sheet containing the formulas you want to change.
From the Edit > Replace
FindWhat: )*0.6
ReplaceWith : )* PercentOfTotal

##### New Member
Ok, I understand but this is not just what I need.
I really want to make a function as a seup and change for certin values in other worksheets from a main worksheet, within to hold workbook system.
For example:

Change grade value for the test: .3
Change garde value for assessments: .7

This will then change all the formulas on the worksheet that does the calculation.

So if the worksheet (Grade Book English) is calculating .6 and .4, which equals 100% total value. Then if the setup requirements change say to .7 and .3 then on the worksheet that is the setup worksheet area for values, the owner can change the value by just typing in the value.

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,168,025
Messages
5,856,890
Members
431,837
Latest member
megantang

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back