Hello to all you experts,
i want to be able to filter a large amount of data to a single row
that i can then use in other areas.

data consists of about 85 columns and 15000 rows of data, much of
which is very similar.
1st filter would have about 15 unique names, each of which then limits
the rows to several hundred
2nd filter will then limit the range to about 100 rows
3rd filter approx 20 rows
4th filter 2 rows
5th filter exact range required.
Autofilter is the perfect option but, it does not allow me to define
the row and then select the data, i.e. any of the 15000 rows could be
the selection so how can i define the relevant cells into other
formulas?
Also even if it did i would have to include this large amount of data
in every file created, up to 20/day.

i was hoping to assemble 5 or 6 drop down boxes on 1 sheet, refer to a
central data file populating the selection criteria for the 2nd with
the results from the 1st etc.

i have rcently posted on this subject and did have a response which
would most likely have given me exactly what i need but at a cost,
unfortunately i need top look for easier and cheaper alternatives.

here's hoping,