Help!

  • Thread starter Thread starter lola
  • Start date Start date
L

lola

Hi

I know this is probably really simple but i can't figure
it out! I have a column of prices, and i need to take away
35% from each of them but can't work out how i do this
have tried highlighting all the ones that i need to take
the percentage away from but can't find out how to take
this away.

any help would be really appreciated.

xx
 
Hi

Enter 0.65 into any empty cell and copy it
Select the range with data to convert, and then PasteSpecial.Multiply - OK
 
The macro below multiplies the current value by 0.65 and
then moves down to the next lower cell. (You could assign
a keyboard shortcut to it if you need to do it
repetitively.)

Sub Macro1()
ActiveCell.Value = ActiveCell.Value * 0.65
ActiveCell.Offset(1).Activate
End Sub
 
Back
Top