Hello,

I am relatively new to VBA programming in Excel. So, I would like to ask you all a question.
Say, I have 10 values in Cells A1, A2, A3.... A 10. And there is a % Value in another cell, let's say B1

A1 - 2 B1 - 50%
A2 - 3
A3 - 4
.
.
A10 - 84

What I want is..a macro that when I click it, it automatically reduces the values of A1,A2..A10, by that percentage. So, when I click on the macro,
my excel sheet should have the values in A1 - A10 reduced to as follows :-

A1 - 1
A2 - 1.5
A3 - 2
A10 - 42

Please help me, and
Thanks !