Thread: [Solved] Button & Macro Help
View Single Post
 
Old 01-07-2017, 04:01 AM
acmo acmo is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Jan 2017
Posts: 1
acmo is on a distinguished road
Default 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
Reply With Quote