i'm trying to figure out a way to put all calculations taking place in the
workbook in one location. It will stop the redundancy of calculations taking
place on multiple sheets. Any advice or help will be greatly appreciated.

Thanks

Hi

Short demo:

Sub test()
Dim i As Long
Application.Calculation = xlCalculationManual
Range("B1").Formula = "=A1*2"
Range("B2").Formula = "=A1*3"
Range("B3").Formula = "=A1*4"
For i = 1 To 5
Range("A1").Value = i
Range("B2:B3").Calculate
MsgBox i
Next
End Sub

HTH. Best wishes Harald

"Monique" skrev i melding
...
i'm trying to figure out a way to put all calculations taking place in the
workbook in one location. It will stop the redundancy of calculations
taking
place on multiple sheets. Any advice or help will be greatly appreciated.

Thanks

I see what the demo is doing, but I'm not sure how that would work with a
bigger platform of information.

"Harald Staff" wrote:

Hi

Short demo:

Sub test()
Dim i As Long
Application.Calculation = xlCalculationManual
Range("B1").Formula = "=A1*2"
Range("B2").Formula = "=A1*3"
Range("B3").Formula = "=A1*4"
For i = 1 To 5
Range("A1").Value = i
Range("B2:B3").Calculate
MsgBox i
Next
End Sub

HTH. Best wishes Harald

"Monique" skrev i melding
...
i'm trying to figure out a way to put all calculations taking place in the
workbook in one location. It will stop the redundancy of calculations
taking
place on multiple sheets. Any advice or help will be greatly appreciated.

Thanks

It is cerainly good idea stop redundancy of calculations. When building
an excel workbook everyone should take care of it. But a particular
solution depends on concrete situation. Smart using of arguments,
lookup functions and forms can be very helpful.
If you describe your work closely help may be more presice.

I have at least 40 worksheets in the current workbook that i'm using. I have
begin the consolidation of information so that I can reduce the redundacy
taking place in the worksheets. However, it has been requested by my employer
that a calculation engine be created so that all calculations are in one
place and end users will not have the ability to change formulas. This is
will just mean that the values from the calculation engine would be stored in
each cell.

This would also make it easier to manage if there were a problem with a
calculation. There would be one central location to look within the workbook,
instead of going to various tabs.

"Roman" wrote:

It is cerainly good idea stop redundancy of calculations. When building
an excel workbook everyone should take care of it. But a particular
solution depends on concrete situation. Smart using of arguments,
lookup functions and forms can be very helpful.
If you describe your work closely help may be more presice.

This doesn't sound like spreadsheet work. Please explain what this is and
what it's supposed to do.

Best wishes Harald

"Monique" skrev i melding
...
I have at least 40 worksheets in the current workbook that i'm using. I
have
begin the consolidation of information so that I can reduce the redundacy
taking place in the worksheets. However, it has been requested by my
employer
that a calculation engine be created so that all calculations are in one
place and end users will not have the ability to change formulas. This is
will just mean that the values from the calculation engine would be stored
in
each cell.

This would also make it easier to manage if there were a problem with a
calculation. There would be one central location to look within the
workbook,
instead of going to various tabs.

"Roman" wrote:

It is cerainly good idea stop redundancy of calculations. When building
an excel workbook everyone should take care of it. But a particular
solution depends on concrete situation. Smart using of arguments,
lookup functions and forms can be very helpful.
If you describe your work closely help may be more presice.

I don't think excel cares where the calculations take place.
However, you mention redundancy. Please explain further.

--
Don Guillett
SalesAid Software

"Monique" wrote in message
...
i'm trying to figure out a way to put all calculations taking place in the
workbook in one location. It will stop the redundancy of calculations
taking
place on multiple sheets. Any advice or help will be greatly appreciated.

Thanks