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
Bookmarks