it would help if you show us a sample of the data you have,and what/how you
want it summarized
--
paul
remove nospam for email addy!



"Payal" wrote:

> I have different worksheets in one excel file containing Numbers and
> alphabets. i want to summarise them to one top sheet so that i can have a
> consolidated data. how do i do it? please help