Reducing numbers by one in defined areas over several sheets
Hi
I need some help constructing a macro.
I have a workbook with 12 sheets , A - L.
In each sheet , range A3 - N35 contains a series of numbers , with some
cells being blank.
I need a macro which will go through each sheet , reducing each number
it finds by 1.
Blank cells should be left blank. Where a cell becomes negative after
subtracting 1 from it , this should be made blank too.
Can someone help?
Grateful for any assistance.
Best Wishes
|