greenbcz
06-06-2017, 08:15 AM
Hi Everyone!
Please find attached a file showing the timesheet of each employee in each row. What i want to do is to have a macro where i will show to each employee his/her 6 months. Let's imagine i hand him an A4 paper and he sees all calendar year by month. I am also adding a monthly view as sample output of code.
As an example, consider JB in the file. The whole JB row for June will go into JB calendar for June. So for JB, we will have 12 calendars that are coming from JB raw on the sheet. So for each employee (which means a row on this sheet) we will have 12 months calendars.
I am newbie to Excel VBA so I need help on this.
Looking forward to favorable responses. Thanks!
Please find attached a file showing the timesheet of each employee in each row. What i want to do is to have a macro where i will show to each employee his/her 6 months. Let's imagine i hand him an A4 paper and he sees all calendar year by month. I am also adding a monthly view as sample output of code.
As an example, consider JB in the file. The whole JB row for June will go into JB calendar for June. So for JB, we will have 12 calendars that are coming from JB raw on the sheet. So for each employee (which means a row on this sheet) we will have 12 months calendars.
I am newbie to Excel VBA so I need help on this.
Looking forward to favorable responses. Thanks!