Starter for 10 points:

I have a price list of our product on a worksheet that has 20 tabs and on each sheet there are a list of prices for each product.

I need to apply a global price decrease of 15% for each price.

Is there a way of setting up a shortcut or key command so that I can highlight a cell or range of cells and it will do the reduction, or alternatively please suggest a method of doing this

The prices are in various columns and rows and in different cells on each tab.

Thanks

1. You can set up extra columns or rows on each sheet to show the discounted price as a function of the original price, eg: discounted price = old price * (1 - GLOBAL_DISCOUNT) where GLOBAL_DISCOUNT refers to a cell you have given that label to on a sheet somewhere

2. Set up the discount in a cell as a fraction (eg: 15% discount = 0.85) and highlight that cell, right click and select Copy (or press Ctrl-C), then select all the cells containing the original prices, and right click, select Paste Special, click on Values (Paste) and Multiply (Operation) and voila, all your prices will have been multiplied by 0.85 = 15% discount.

But you have to to do the Copy/Paste Special (Multiply) sheet by sheet (I think). Plus if you change your mind and want the original prices back, you have to "undo" the discount, so I would always use method 1 to provide some transparency into what's going on.

Thanks Dave

Job done