Hello,
in Sheet1 is a database with names, addresses, telephone numbers and so on.
More or less like this:
Surname1 Name1 Rank1 Officenumber1 Homenumber1 Address1
Surname2 Name2 Rank2 Officenumber2 Homenumber2 Address2
Surname3 Name3 Rank3 Officenumber3 Homenumber3 Address3
Surname4 Name4 Rank4 Officenumber4 Homenumber4 Address4
In Sheet2, using a macro people here helped me to fix, i keep notes of people's leaves or absence, like this:
Everytime someone gets a leave or is away for medical reasons, i select start and end of leave in 2 drop calendars, i select the reason or kind of leave and press a button.
Then next to the list of names in Sheet2, the cell takes the form of "5 KA-1/11/2010" for example where 5 is the number of days, space and then the type of leave, "-" and finally the first day of his leave. Also each of these cells changes color for the leave type. Exaple, a cell with "KA" is red. A cell with "PA" is green and so on.
The Sheet2 is like this:
Surname1 5 KA-7/10/2010 3 PA-1/11/2010
Surname2 3 PA-5/11/2010
Surname3 5 KA-1/11/2010
Surname4 10 FA-25/10/2010 5 KA-15/11/2010 etc.
Now what i need to do is:
In order to fill Sheet3 every first of a month which is actually a report for those who where absent even at least one day that given month, i need to have a macro in a button which i will press after selecting a month, so that it will detect who had a change in this selected month and then go in Sheet3 and complete various data from sheet1 and sheet2.
For example, surname, name, rank, address, a custom text which will describe his period and length of absence etc.
Then i will print this sheet3 (report).
Example for October based on "Sheet1" above:
Surname1 Name1 Rank1 5 days KA to Athens from 7/10/2010 Address1
Surname4 Name4 Rank4 10 days FA to Rome from 25/10/2010 Address4
Thank you for your time.
John
in Sheet1 is a database with names, addresses, telephone numbers and so on.
More or less like this:
Surname1 Name1 Rank1 Officenumber1 Homenumber1 Address1
Surname2 Name2 Rank2 Officenumber2 Homenumber2 Address2
Surname3 Name3 Rank3 Officenumber3 Homenumber3 Address3
Surname4 Name4 Rank4 Officenumber4 Homenumber4 Address4
In Sheet2, using a macro people here helped me to fix, i keep notes of people's leaves or absence, like this:
Everytime someone gets a leave or is away for medical reasons, i select start and end of leave in 2 drop calendars, i select the reason or kind of leave and press a button.
Then next to the list of names in Sheet2, the cell takes the form of "5 KA-1/11/2010" for example where 5 is the number of days, space and then the type of leave, "-" and finally the first day of his leave. Also each of these cells changes color for the leave type. Exaple, a cell with "KA" is red. A cell with "PA" is green and so on.
The Sheet2 is like this:
Surname1 5 KA-7/10/2010 3 PA-1/11/2010
Surname2 3 PA-5/11/2010
Surname3 5 KA-1/11/2010
Surname4 10 FA-25/10/2010 5 KA-15/11/2010 etc.
Now what i need to do is:
In order to fill Sheet3 every first of a month which is actually a report for those who where absent even at least one day that given month, i need to have a macro in a button which i will press after selecting a month, so that it will detect who had a change in this selected month and then go in Sheet3 and complete various data from sheet1 and sheet2.
For example, surname, name, rank, address, a custom text which will describe his period and length of absence etc.
Then i will print this sheet3 (report).
Example for October based on "Sheet1" above:
Surname1 Name1 Rank1 5 days KA to Athens from 7/10/2010 Address1
Surname4 Name4 Rank4 10 days FA to Rome from 25/10/2010 Address4
Thank you for your time.
John