PROBLEM: "I have a data validation list in a specific cell, the choice I make in that one cell causes my entire sheet to recalculate for the department chosen. I need to cycle through every option in that drop down and print the sheet, once for each possible value.
- Only need to identify which cell to operate from in the macro, colored in the macro below
- Data Validation list is not to be defined in the macro, the macro should detect the listrange automatically
- Macro selects each item from that DV list and reprints the active sheet, then repeats
- Added ability to cycle through a DV list that is built in rather than based on a range of cells, too
Nothing says "thanks" like a steak dinner!