I have some working knowledge of VBA though it is limited. If I could get a generic script for this I am sure I can apply it to my specific workbook. Below is what I am trying to do.
I have a drop down list “Facility”
What I would like it to do is pull all relevant dates from a dynamic list and place them in a new drop down list “Dates”.
When a date is selected
I want to have the data in the corresponding Row “A:Z” test for any cell that as a value of “No”
For every cell reporting a value of “No” the corresponding header of the column where “No” is found Should report to a row in a table “Non_compliant"
Thank you in advance, this is a great place for help in learning VBA.
I have a drop down list “Facility”
What I would like it to do is pull all relevant dates from a dynamic list and place them in a new drop down list “Dates”.
When a date is selected
I want to have the data in the corresponding Row “A:Z” test for any cell that as a value of “No”
For every cell reporting a value of “No” the corresponding header of the column where “No” is found Should report to a row in a table “Non_compliant"
Thank you in advance, this is a great place for help in learning VBA.