OK...No advanced filter.
How about a pivot table? (See attached jpeg)
Once it is set up, users only need to click Refresh on the pivot table
to get the latest data.
Is that still too techie for them or would that meet your needs?
Ron
+-------------------------------------------------------------------+
|Filename: Pivot1.JPG |
|Download:
http://www.excelforum.com/attachment.php?postid=3466 |
+-------------------------------------------------------------------+
--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread:
http://www.excelforum.com/showthread...hreadid=375860