Link 2 sheets

[Guest]

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 ?

 

[Frank Kabel]

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/2004/11/26/creating-a-simple-pivot-table/trackback/