I would like to create a macro that ask a question, question I am looking to ask is Please enter percent
Once the user enters in a percent say 25
I would then like it to update a range of cells that already have information in them
So for example I have these rows which has a unit price in them.
When the user enters 25, it will change the 1st row to 1.25, the second row to 2.50 etc.
Once the user enters in a percent say 25
I would then like it to update a range of cells that already have information in them
So for example I have these rows which has a unit price in them.
When the user enters 25, it will change the 1st row to 1.25, the second row to 2.50 etc.
Unit Price |
$1.00 |
$2.00 |
$3.00 |
$4.00 |
$5.00 |
$6.00 |
$7.00 |
$8.00 |
$9.00 |
$10.00 |