My colleague and I were given a task to have a cell stay or disappear and changed based on a drop down. So for example, in the attached spread sheet we would need the Seedless category to disappear when vegetable is selected. Then the Color would move up in its place. Is there a way to do this with VBA? Also, this example was made quickly before work ended, so don't laugh to hard.
11.9 KB Views: 3