Forum Discussion
INCREASE VALUE ON SEPERATE SHEETS
Attention Advisor,
I am currently using excel spreadsheet for costs and quotes on customers.
I have one sheet up with part numbers and my costs on them, and what would make it very simple and beneficial for me is if I could set up separate sheets and have the costs get adjusted accordingly. For example lets say in sheet #1 it would have my cost in there, and sheet #2 it would have cost plus 10%, sheet #3 would be cost plus 20%. But if my costs change, it would be fantastic if I could adjust the price on sheet #1 and the other sheets would follow suit and adjust it automatically, rather then going into each individual sheet and adjusting every single time my cost goes up. Is anything like this a possibility?
1 Reply
If the structure of the sheets would be the same, you can use formulas.
Let's say prices are in D2 and down on Sheet #1.
In D2 on Sheet #2: ='Sheet #1'!D2*110%
In D2 on Sheet #3: ='Sheet #1'!D2*120%
Etc.
Fill down.
