Button & Macro Help
Hi all, newbie here. I have created a simple book for costing purposes at work, fill out each sheet that applies and the final sheet has the outcome filtered to it.
As a default I have the markup on products and materials set to 20% eg (G4*1.2)
What I would really like is a series of buttons on each sheet to give the option of markup percentage
eg button 1 10% (g4*1.1,H6*1.1,K28*1.1)
button 2 20% (g4*1.2,H6*1.2,K28*1.2)
button 3 25% (g4*1.25,H6*1.25,K28*1.25) and so on.....there are multiple cells on each sheet for these buttons to apply to.
I have no idea what I am doing with code but will pick it up if someone can give me a kickstart!!
Thanks in advance
|