Dynamic Dropdown with list report out

Hardhat

New Member
Joined
Jul 28, 2017
Messages
23
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.
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,871
Office Version
  1. 365
Platform
  1. Windows
Consider posting sample data to illustrate requirements, showing the original data and required results
Click on XL2BB above reply window to download a tool that can help you do this
 

Watch MrExcel Video

Forum statistics

Threads
1,112,997
Messages
5,543,193
Members
410,584
Latest member
Bluefox68
Top