Link 2 sheets
 

I keep a list of all 200 products we sell and how many of each sold per month.
I would like excell to automatically list a top ten list on another sheet.
How can I do this ?

Hi
I'd try a pivot table for this. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2...ble/trackback/

--
Regards
Frank Kabel
Frankfurt, Germany
"bruno borgata" <bruno schrieb im
Newsbeitrag ...
I keep a list of all 200 products we sell and how many of each sold per
month.
I would like excell to automatically list a top ten list on another sheet.
How can I do this ?