Hi All,
I need to automate below task. I have multiple sheets where team where team member’s achievements mentioned. In sample workbook I have added 2 sheets only however I have around 10 to 15 sheets in actual. I need to build matrix where below things should come up.
Please refer attached workbook for the same. Please help me how can solve this issue.
I need to automate below task. I have multiple sheets where team where team member’s achievements mentioned. In sample workbook I have added 2 sheets only however I have around 10 to 15 sheets in actual. I need to build matrix where below things should come up.
- If any team member have achievement then only macro or formula should pick up data (Please refer column Achievements)
- If achievement in same or in same month or in same date it should NOT skip. It must appear in output data
- In raw data (Sheet DR & TL)columns can be changed hence it should not affect our result
Please refer attached workbook for the same. Please help me how can solve this issue.