I have a list on a worksheet to organize purchases by the buyer where each
the first column designates
whether the purchase is a book...b or music...m or video...v.
I want to make a master sheet where all the buyer's information is sorted by
the catagories listed above.
So if Sam bought 1 book 1 video and 1 music (on one worksheet) and Paul
bought 2 books
5 videos and 2 musics(on another worksheet), how do I show on a master sheet
the date resorted to show all the books music etc in separtate catagories . I
want to not just count the books etc, but have the information that follows
in the row (the title cost etc.)copy to the master sheet as well. Thanks for
anyone's help...

I'm not sure if I understood your problem. But did you try autofilter?


--
hideki
------------------------------------------------------------------------
hideki's Profile: http://www.excelforum.com/member.php...o&userid=18903
View this thread: http://www.excelforum.com/showthread...hreadid=396881