How to have multiple sheets show active items from a master sheet containing statuses?

Reji

I have a master sheet and want to feed multiple other sheets information from it.

• Master spreadsheet: is an employee roster, listing all employees and their status (active, inactive)
• Sheet 1: has a list of required training and training expiration dates
• Sheet 2: has a list of company assets assigned to each employee

I want to be able to setup Sheet 1 and Sheet 2 to generate a list of "active" employees only from the Master Sheet. I will update the Master Sheet every time there's a change, new employees added or change in status.

Is it possible for Sheet 1 and Sheet 2 to automatically pull only the employees marked as active from the Master Sheet so I always have a list of active items to look at on both sheet?

Thank you for the assistance!

kowal

hi @Reji if you want to have multiple sheets data to go into one sheet you have two options:

1. Reports - and you can create the sheet summary report.
2. Cell linking