jaydee
05-14-2018, 07:23 PM
Hi all,
I have a cost sheet that is calculating totals (highlighted in yellow), with or without a manager’s discount (there is a dropdown in cell F4 that allows me to toggle between the two options). Is it possible to have another dropdown, say cell F5, which would allow me to show just the totals with a manager’s discount? This would be all amounts with an “x” in column V, but every other amount would be zero when toggled. I have to do this with 5 different locations, so I'm trying to minimize the amount of manual work.
I use the totals to create a sell sheet which has all of our prices, but I also need to create another sell sheet with just the manager specials, so people can see what is on sale, and not cluttered up with the other values. Is this possible?
Thank you for your time and consideration.
I have a cost sheet that is calculating totals (highlighted in yellow), with or without a manager’s discount (there is a dropdown in cell F4 that allows me to toggle between the two options). Is it possible to have another dropdown, say cell F5, which would allow me to show just the totals with a manager’s discount? This would be all amounts with an “x” in column V, but every other amount would be zero when toggled. I have to do this with 5 different locations, so I'm trying to minimize the amount of manual work.
I use the totals to create a sell sheet which has all of our prices, but I also need to create another sell sheet with just the manager specials, so people can see what is on sale, and not cluttered up with the other values. Is this possible?
Thank you for your time and consideration.