You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can I copy formulas?

Accepted answer
1
Views
3
Comments

Summary:

In the report I have three columns: Actual in column B, Budget in column C, and variance in column D. Formula in column is [B]-[C].

Now I want to replicate it 13 times to have total year and 12 months. When I copy it, the variances in all 13 groups will be calculated as [B]-[C], so I'll have to go and correct each formula.

Is there any way to set the formulas so they'd copy formulas as a variance between two previous columns rather than two hardcoded columns?

For instance, in this example below I wanted to see a formula that would calculate variance between W and X rather than variance between B and C.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!