Generate Report using Macro

[Kohinoor]

I have a workbook consisting of Employee name, Ids and their respective due dates for salary. The due dates falls every month which varies from Employee to Employee . Is it possible to generate a report and paste it in a new excel sheet naming it automatically as REPORT Month and date wise.

The macro should go through the entire sheet for Due dates and upon clicking a button I should be able to generate the reports.


I have attached the sheet for your reference.


Thanks in advance

Jane