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

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,872
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,118,311
Messages
5,571,487
Members
412,397
Latest member
Phillip Rogers
Top