Auto-Populating a sheet based on criteria from other sheets?

[janinebmccormick]

Good Morning!

I am new to using Excel, and don't have any experience with Micros or VBAs. Also, I won't be able to provide a sample of my spreadsheet, as it contains sensitive information. Hopefully I can clearly explain what I'm seeking help for.

I have a master list with several fields, such as name, email address, department, supervisor, etc. The list is used to track licenses and certifications, particularly when they will expire. What I would like to do is create a macro that goes through this master list, identifies individuals with licenses/certifications expiring withing 60 days, and populates a list on another sheet.

Does this even sound possible? Any help is greatly appreciated

[ImranBhatti]

You may upload a sample workbook with dummy data.
What I understood from your explanation. You have a column with the expiry dates of the licenses. assuming those dates are in B column you may use this formula in CF.

=AND(B2<=EDATE(TODAY(),2))

See if the attached helps you.If not please put manuall results in the workbook and reattach it with further explanation.