.
The following works 99% of the time - occassionally it will fail and requires a closing / reopening of the workbook.
Please review and advise if there is a better way of accomplishing the goal.
Two dropdowns ( B3 & C3 ) attached to the Sheet_Change event. B3 creates a query for Database Sheet Col E ...
C3 creates a query for Database Sheet Col F ...
As shown, the overall goal is to have two individual dropdowns that will initiate a query - one for Col E and the other for Col F.
Thank you for looking .
Please Login or Register to view this content.
Bookmarks