'Extract excel range of data dependent on user input (yes or no)
How can I extract a range of cells (from a sheet) and extract said range of cells to an additional excel sheet based on user input (yes or no drop down menu)? The desired result would a "Results" excel sheet that contains ranges of cells only answered "Yes" from the yes or no drop down menu.
In my Home Inspection example, the first sheet is a Questionaire sheet asking the user what components (i.e. garage, pool, yard, basement) the house has. In this example, GARAGE, and BASEMENT is marked YES.
Each of the following sheets (Garage Inpsection, Pool Inspection, Yard Inspection, Basement Inspection) will contain a range of checklist questions.
Based on the user input from the "Questionaire" sheet, a "Results" sheet will contain the range of cells from the sheets referencing "YES" from the drop down list in the Questionaire sheet.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|