Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
    
Hello roman_bull. You have a low accept rate. I looked at your older questions and at least one was answered successfully. Maybe you can have a look again and accept them if possible. –  nixda Jan 1 '13 at 13:17
    
Thank you for reminding me..I had missed out on accepting those answers...!! –  roman_bull Jan 1 '13 at 13:53
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.