VBA to Create weekly & Monthly wise summary with change shown in another sheet.

My Dear Experts,

I need one big help... I m preparing weekly reports which eating me lot of time doing copy and pasting each week of employee count and category.

I need help to create a VBA codes for this report to generate on weekly basis.

1. Automatically add employee counts based on category in weekly wise , week1, week2, week3 , week4 and week5 till December ( Sample table created at main summary)

2. Automatically add employee counts based on category in Month wise , Jan, Feb , Mar till December average count of all 3 months ( Sample table created at main summary)

3. Whatever changes happens in basedetails sheet at any cells file it should go copy and paste the entire row and highlight the changes in RED color in particular week on weekly basis ( this ill go till December. if new employee added it should reflect in YELLOW color ( Created Changes sheet Result ).

4. I have attached sample employee number.. there are more than 2800 people working in our team.

I need full support from this forum to create this report, i m spending lot of time to prepare on weekly basis doing copy paste on each week and added 2800 lines on each week. I dont want to do this.

Let me know if any more information required

I know this is not impossible to you guys in this forum.


With regards,
KumarPK