Generate Report using Macro

[Topazpower]

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

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
1	S.No	Ref No	Employee ID	Employee Name	Days	OT	Basic	DOJ	Amount Payable	1st Due	2nd Due	3rd Due	4th	5th	6th	7th	8th	9th	10th	11th	12th	13th	14th	15th	16th	17th	18th	19th	20th	21st	22nd	23rd	24th
2	1	109	MDB100001	John	30	0	500	12-Mar-09	500	11-Apr-09	11-May-09	10-Jun-09	10-Jul-09	09-Aug-09	08-Sep-09	08-Oct-09	07-Nov-09	07-Dec-09	06-Jan-10	05-Feb-10	07-Mar-10	06-Apr-10	06-May-10	05-Jun-10	05-Jul-10	04-Aug-10	03-Sep-10	03-Oct-10	02-Nov-10	02-Dec-10	01-Jan-11	31-Jan-11	02-Mar-11
3	2	110	MDB100002	Rivera	30	0	500	14-Mar-09	500	13-Apr-09	13-May-09	12-Jun-09	12-Jul-09	11-Aug-09	10-Sep-09	10-Oct-09	09-Nov-09	09-Dec-09	08-Jan-10	07-Feb-10	09-Mar-10	08-Apr-10	08-May-10	07-Jun-10	07-Jul-10	06-Aug-10	05-Sep-10	05-Oct-10	04-Nov-10	04-Dec-10	03-Jan-11	02-Feb-11	04-Mar-11
4	3	111	MDB100003	Mary	30	0	500	14-Mar-09	500	13-Apr-09	13-May-09	12-Jun-09	12-Jul-09	11-Aug-09	10-Sep-09	10-Oct-09	09-Nov-09	09-Dec-09	08-Jan-10	07-Feb-10	09-Mar-10	08-Apr-10	08-May-10	07-Jun-10	07-Jul-10	06-Aug-10	05-Sep-10	05-Oct-10	04-Nov-10	04-Dec-10	03-Jan-11	02-Feb-11	04-Mar-11
5	4	112	MDB100004	Sweta	30	0	500	14-Mar-09	500	13-Apr-09	13-May-09	12-Jun-09	12-Jul-09	11-Aug-09	10-Sep-09	10-Oct-09	09-Nov-09	09-Dec-09	08-Jan-10	07-Feb-10	09-Mar-10	08-Apr-10	08-May-10	07-Jun-10	07-Jul-10	06-Aug-10	05-Sep-10	05-Oct-10	04-Nov-10	04-Dec-10	03-Jan-11	02-Feb-11	04-Mar-11
6	5	113	MDB100005	Brian	30	0	500	17-Mar-09	500	16-Apr-09	16-May-09	15-Jun-09	15-Jul-09	14-Aug-09	13-Sep-09	13-Oct-09	12-Nov-09	12-Dec-09	11-Jan-10	10-Feb-10	12-Mar-10	11-Apr-10	11-May-10	10-Jun-10	10-Jul-10	09-Aug-10	08-Sep-10	08-Oct-10	07-Nov-10	07-Dec-10	06-Jan-11	05-Feb-11	07-Mar-11
7	6	114	MDB100006	Fina	30	0	500	17-Mar-09	500	16-Apr-09	16-May-09	15-Jun-09	15-Jul-09	14-Aug-09	13-Sep-09	13-Oct-09	12-Nov-09	12-Dec-09	11-Jan-10	10-Feb-10	12-Mar-10	11-Apr-10	11-May-10	10-Jun-10	10-Jul-10	09-Aug-10	08-Sep-10	08-Oct-10	07-Nov-10	07-Dec-10	06-Jan-11	05-Feb-11	07-Mar-11
8	7
9	8
10	9
Sheet1

 

[ColinKJ]

Hi Jane,

I would need you to clarify the search criteria.

If you were just click the button with your example data say on 1st April, from your example can you show me what results you would expect.

Regards

ColinKJ

 

[jbeaucaire]

http://www.excelforum.com/excel-general/676718-generate-report-using-macro.html

 

[Topazpower]

I actually require a report for each employee about the due date for salary based on the search from cell J2 to AG2. Since the salary date vary from one person to other person I require that in advance before 5 days of the due date mentioned .

The Report should have the Employee Id, name and the date of salary to be paid along with the amount payable.

Thanks
Jane.

 

[ColinKJ]

Hi Jane,

I've put together a WB which you could take a look at, send me a private message with an email address, and I'll send it over.

ColinKJ

 

[ColinKJ]

Hi Jane,

I have a WB for you to take a look at. Do you still want it, if so, send me a private message with an email address, and I'll send it over.

If you don't want it now can you let me know.

Regards

Colin