I saw a similar posting asking a similar question, but didn't see what I wanted, so thought I'd try asking it this way.

I have a sheet with a drop-down menu where the user selects a plant from the list, which then populates data in a table for that specific selected plant. I then have the user hit a button to "update" which hides unused rows. I'd like the selection of the item on the drop-down menu to trigger the macro, so they don't have to hit the update button as well. I know it seems pretty simple to select the item then hit the button, but some users won't hit the button and then will wonder why they have extra rows showing up.

Thanks in advance.
David