If you created as many pivot tables (preset for each catagory) as you needed
for your report and used "Field Settings/Advanced/Descending/Using field:
Top five numbers" you would not have to sort each time.
Then link the pivot table data to your report.
A macro like the one below would let you refreash all the pivot tables in
the workbook at once.
Sub test()
ActiveWorkbook.RefreshAll
End sub
Don
Dnereb" wrote in
message ...
It is possible in Excell but Access is far better for this (or any other
database)
to find the top 5 of something in a database youy can use a SQL query
like
"SELECT TOP 5 Table.Asset FROM Table"
BTW 1000 or more records of data should be stored in a database anyways
--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile:
http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=486512