• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto populate a different sheet with list of rows including header based on filter criteria applied on top of selected down downs on columns

rugadameghanath

New Member
I have 6 columns, with 4 columns to be filtered with different criteria based on selection made from the dropdowns created from the same columns duplicate data

SOURCE DATA and ITS DUPLICATION in two sheets

Selection criteria in the source data sheet

DROP DOWNs loaded as list from duplication data

Output of rows to be auto populated to a different sheet whenever a selection is made in the drop down

Attaching the excel with the data i have as sample for my experiment.
 

Attachments

  • sample data.xlsx
    14.5 KB · Views: 11
Back
Top