Continuously Update Sheets Based on Master

Hello,

I have an Excel 2010 workbook with several spreadsheets. The first spreadsheet, "Master" houses all data of the youth we serve or have served in our programs this school year and if we have Releases of Information for them. I am trying to firgure out the best way to auto-populate rows of data into separate spreadsheets. The spreadsheets would be as follows: "Active" (populate the youth that have open admissions- in other words blank discharge dates- in two specifcic programs, Program X and Program Y under column K), "ABC Active" (the youth that have open admissions in Program ABC only under column K), and "Missing ROIs" (the youth that have 'N' in column J).

Essentially, I would like to edit data in "Master" and have the rest of the sheets automatically update based on the criteria. I have attached an example.

Thank you in advance for any help!

Please Login or Register  to view this content.

I tried the above code from another thread. I tried to change the corresponding criteria to match mine but with no luck. This code is the original posted by the solver. I haven't dabbled in VBA in about 10 years so it's been a while! I also tried to record a macro.

It worked! Thank you!! However--is there a way to make the top row (column names) copy as well? The top row is blank after it populates the data. Also, what can I put instead of "CLOSED" since I am trying to filter those that are NOT that criteria? In other words, I want to know which rows of data have a blank cell in "Discharge Date."

removed for redundancy

What do you mean by keep the filter ability?

EDIT: Apply the change to each line specific to sheet, so the below:
EDIT2: The below will also filter based on the blank cell in column 3 and not closed in column 10
EDIT3: The code was copying the entire range regardless of filtered values. The below code fixes that.

Please Login or Register  to view this content.

see below
EDIT: If you are meaning that you WANT them to copy rows in which the discharge date is blank, remove the <> inside the quotations in the 2 if statements

Please Login or Register  to view this content.

You are most welcome! :D

If I've helped you, please consider clicking the star in the bottom left and adding some reputation

EDIT: You're a rockstar, I see that you already have! Good luck!
EDIT2: Consider marking the thread as "SOLVED" under thread tools in the top right