Pricing sheet in excel
Budget: £20 – £250 GBP
I have designed an input form in Excel where you can select options from multiple drop down menus. Each option of each drop down menu has a price attributed to it. I need someone to use VBA to connect everything together with a total price for each item and a grand total at the end. I need to be able to change the prices on the master sheet in the future. I also need the master sheet to be protected by a password. There are a couple of maximum and minimum sizes on the widths and heights with a surcharge over a certain width and height.