I have the following worksheet and would like to have a current population count as well as extrapulate information to a worksheet with only the active population shown with all the information for each name

Name Sex DOB Date In Time In Date Out Time Out

The current population would be between 12:00 AM Time In and 12:00 AM Time Ou

12:00 AM and <12:00 AM for Time Ou

The first worksheet would be a history worksheet and the second would be current only