I have a large spreadsheet (some 25000 lines) with headings including
make, model & price. I use this as a lookup table to value other
lists.
If I have a list of say 100 items I lookup each item using autofilter
and extract from the data table the number of items, the max. price,
min. price and average. I am looking for a way to do this automatically
by using a macro
I know this is a complicated one, can anyone help?


--
tryer
------------------------------------------------------------------------
tryer's Profile: http://www.excelforum.com/member.php...o&userid=16546
View this thread: http://www.excelforum.com/showthread...hreadid=392501