How can I update pricebook increases in different percentages

[Guest]

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.

 

[Gord Dibben]

Diane

Are the structures of each worksheet the same?

If so, you could "group" the sheets and apply an increase to all.

Enter a number like 1.1 in an unused cell on first sheet and copy that cell.

Then right-click on first sheet tab and "select all sheets"

Select the range of prices on first sheet and paste special>multiply>ok>esc.

All prices on all sheets will be increased by 10%

Right-click and "ungroup". Clear the cell with 1.1


Gord Dibben MS Excel MVP

 

[Guest]

Diane

Are the structures of each worksheet the same?

If so, you could "group" the sheets and apply an increase to all.

Enter a number like 1.1 in an unused cell on first sheet and copy that cell.

Then right-click on first sheet tab and "select all sheets"

Select the range of prices on first sheet and paste special>multiply>ok>esc.

All prices on all sheets will be increased by 10%

Right-click and "ungroup". Clear the cell with 1.1


Gord Dibben MS Excel MVP

 

[Guest]

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. I was able to do as you suggessted, but can I make it
work in this three column set up?