Button to / cells - DRIVING ME MAD PLEASE HELP!

[mattbarb]

Hi,

I’m trying to create 3 macros to divide the value in cell D and place the percentage in E (for the range E5:E46) using a button. Ive tried several methods but all have failed.

/2 (small button pressed)
/3 (medium button pressed)
/4 (large button pressed)

Many thanks,

Mattdemo.xlsx

[x65140]

what about this....

[mattbarb]

Fantastic. I just wasted 2 hours what you did in 5 mins! Thanks so much!!!

Matt

[mattbarb]

Hi,

Is it possible to remove the 0 value from appearing in the sheet. I had a look at doing a range i.e. E5:E7, E9:E11 etc but it didnt work.

Many thanks

MattScreen Shot 2014-12-05 at 10.25.26.png