I have an excel file with multiple tabs for each category of my price book. I
need to set this up with an easy way to be able to globally update all these
prices with a percentage increase without going to each page.
The structure of the first page is a contents page and the rest are the same
structure. The first column of numbers is the actual price, the second column
is the price marked up a certain percentage and a third column marked up
another percentage.
Is there a formula that will quick update all tabs, not changing the first
column of prices, but updating the second column by one percentage and the
third column by a different percentage