Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an attendance register, needed to be maintained as monthwise separate sheets. Each sheet adds number of leaves taken under each heading by a person. This needs to be summarized on a single sheet for each person from different sheets. The order of people in sheets may vary.

enter image description here How do I achieve this please?

share|improve this question
Thank you for reminding me..I had missed out on accepting those answers...!! – roman_bull Jan 1 '13 at 13:53
up vote 0 down vote accepted

Combine all the individual monthly sheets. (Jerry Beaucaire has a macro to do this if manually is too tedious). Because you specify “need to maintain as monthwise separate sheets”, from the combined sheet each month filter each month for the required month and then copy the result to a new sheet with an appropriate name.

Create your summary with a pivot table. This is much more versatile for analysis and altogether avoids the need for formulae to achieve the result you want. If you want the summary for each person on a separate sheet (“needs to be summarized on single sheet for each person from different sheets”) filter the summary and copy the result to separate sheets. However if you mean summarized for every person on a single sheet there is no need for filtering and copying - the pivot table is sufficient.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.