Pete
09-08-2008, 11:00 AM
see attached workbook
Hi Experts
Need a macro that well do the following when the user enter a value into the table as shown in worksheet "Scenario 1" columns T:X
Sequence of steps
1. If the user add the value 2 to column V2 (Against ALL Products) then all the product in column N, row 10 onwards in worksheet "Scenario 1" increase by 2%.
2. The value in cell v2 worksheet "Scenario1" changes once the macro button has been clicked to bold font and colour red, making the user aware.
3. If the user click the reset button they return back to the origianl value less the increase and the colour red and bold font
Hi Experts
Need a macro that well do the following when the user enter a value into the table as shown in worksheet "Scenario 1" columns T:X
Sequence of steps
1. If the user add the value 2 to column V2 (Against ALL Products) then all the product in column N, row 10 onwards in worksheet "Scenario 1" increase by 2%.
2. The value in cell v2 worksheet "Scenario1" changes once the macro button has been clicked to bold font and colour red, making the user aware.
3. If the user click the reset button they return back to the origianl value less the increase and the colour red and bold font