Reduce numbers by a certain percentage

[bidsdaddy3]

All,

I am new to VBA and want to create a spreadsheet that automatically adjusts the numbers by a certain percentage based off production.

For example, each cell is a bay and contains the production numbers for a given month. If events happen that decrease the production ability (i.e. 90%), I would like to place that # in the cell (H2) and reduce all numbers (B8:P21) by that percentage. Could anyone help me with what code I would need in VBA to accomplish this? Thanks in advance.

[arthurbr]

Hi and welcome to the board

You can record a macro which does the following
Select and copy H2,
Select the range B8:P21 -
Select Paste special
Select multiply- OK

[royUK]

I would think you could do this with formulas. Attach an example workbook