I have created a Price List for my company that contains 5 different options. Depending on which list they select (from a drop down), the price for services change. However one of the options they can select from the list, has additional services that are listed. I am wondering if there is a way to hide/display rows depending on what list is selected. The list that the select is on a different worksheet than where all the prices are located. I have all the services listed on the 2nd sheet, but I want rows to hide or display depending on what is selected from the drop down?
This would make many members of my company happy if this can be done.
This would make many members of my company happy if this can be done.
