Hi,

Dear I am beginner in EXCEL,

Can anybody explain me, How to make list of Items displayed in AutoFilter?
Any Function?

Currently I am doing manually by each individual items using autofilter,then
Copy-paste. This consumes lot of time and hundreds of items are there. e.g.

Datasheet

Apple 1
Apple 2
Apple 9
Banana 3
Banana 4
Carrot 5
Doll 1
Doll 7
Doll 5
Doll 6


List - Summary sheet

Apple 12
Banana 7
Carrot 5
Doll 19


Please help. I have tried to know by help but not succeded.

Thanks in advance!