HI Friends,
I have a problem please help me to solve it. I have the monthly attendance reports and I want a summary of yearly. I am doing it manually and I want automatically,
Please help me to solve this. Attached a sample data for your reference
If you can ensure that the summary for each month will start from column AH onwards , and that the list of employees in each month will be in the same order , then the formula is simplified.
All you have to do is ensure that all the months are prior to the Summary tab , and you can have all the month tabs created right now , and fill in the data later.