Help organizing date
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 |
All times are GMT +1. The time now is 05:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com