I want a cell to automatically calculate a value I enter with a preexisting formula

[JaredTek]

OK so I don't want to have to enter a formula every time. I just want to come to a premade sheet, enter a few values, and have the whole sheet populate given the inputted data.

Let's say I'm using B10. I want to mosey on over to B10, enter a number without having some existing formula pop up, and have it automatically calculate the value - The formula is irrelevant, I want to know how to do this as a function.

I've tried working self referentially, eg using the selfsame cell as the reference, but I don't think excel is fond of the endless regress.

As a working example, I want cell d10 to calculate the GST (New Zealand) of let's say $11.5. All I want to do, Is type into the cell 11.5, and then it automatically changes the number to the given GST value, in this case $1.50. I know lots of things on excel, but I don't know this. Getting close to hulk smash keyboard.

[BadlySpelledBuoy]

You could use a VBA worksheet change event that fires when you change a specific cell/range of cells.

Right click the sheet tab and select "View Code" then paste the below in the code window.

Please Login or Register  to view this content.

BSB