I want to do the following:
I created this spreadsheet that takes care of steps 1 and 3, but I am hung up on step 2. How do filter the list so it only shows dates for the selected site?
I need your creative help? I am open to using VBA, Active X Combo Boxes, whatever you think would get the job done.
- Create a connection to a site like this one.
- Filter the data based on SITE.
- Select a date and populate a form for that SITE/Date
I created this spreadsheet that takes care of steps 1 and 3, but I am hung up on step 2. How do filter the list so it only shows dates for the selected site?
I need your creative help? I am open to using VBA, Active X Combo Boxes, whatever you think would get the job done.