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...
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.