consolidate tables

[OWAIZ]

HI CHAMPS,

I have five table on sheet1 each table contains 3 coloum (eg name,absent,late) the names are repeated in all the five tables, with different absent numbers and late numbers, on sheet 2 i intend to have a single table with all 3 coloums, which will give me all the names from all that 5 tables without repeating them & and suming up the total number of absent and total number of lates...

pls guide me

Hope i was able to put the question properly

Regards
OWAIZ

 

[OWAIZ]

Boss,

Will appreciate if u can attach a sample or can e-mail me a sample on a_shop@rediffmail.com

WIll make things clear

thanks & regard
OWAIZ

 

[Mark W.]

See the Excel Help topic for...

- "Consolidate data by category"