How to Auto-populate sheets in a workbook with data

Hi everyone,

I have pretty basic excel knowledge and I know that what I"m asking to do is possible because I've used a spreadsheet with the functions i am trying to create I just don't know how to do it so i joined this page to see if someone out there can help me. THANKS IN ADVANCE!!!


I have a table with the following data :


File Number File Name Date Opened Lawyer Division Notes Date Closed
12345 John Smith 01-02-2020 VES Education subfile 08-05-2021

What I want to be able to do is transfer the rows with date in the " Date closed " column into a separate sheet
so all my closed files are in one place and all my open files in the other.

PLEASE HELP ME!!!!!! It would make my job a whole lot easier!!!!

Please Login or Register  to view this content.