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!
Bookmarks