How can I update pricebook increases in different percentages
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. |
How can I update pricebook increases in different percentages
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 specialmultiplyokesc. 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 On Fri, 23 Feb 2007 16:30:53 -0800, Diane wrote: 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. |
How can I update pricebook increases in different percentages
"Gord Dibben" wrote: 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 specialmultiplyokesc. 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 On Fri, 23 Feb 2007 16:30:53 -0800, Diane wrote: 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. |
How can I update pricebook increases in different percentages
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? "Gord Dibben" wrote: 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 specialmultiplyokesc. 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 On Fri, 23 Feb 2007 16:30:53 -0800, Diane wrote: 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. |
All times are GMT +1. The time now is 12:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com