I actually have a two part question of which I am sure the answer to the first question is no.
Can I create a drop-down list from a series of cells that has a blank cell or two in the middle?
DROP DOWN CELLS
Option 1
Option 2
Option 3
Option 4
My second question is why I am here. How can I execute a macro once a selection is made from a drop-down list?
Can I create a drop-down list from a series of cells that has a blank cell or two in the middle?
DROP DOWN CELLS
Option 1
Option 2
Option 3
Option 4
My second question is why I am here. How can I execute a macro once a selection is made from a drop-down list?