Newbie : Advanced Filter Criteria
I am using Excel 97.
Our firm has a master spreadsheet that contains all sales information. The managers want me to create an easy to use form that can extract information from the spreadsheet. I wanted to use Advanced Filter Criteria. However, the help file is no help. Also, I can't seem to find good examples on the Internet. Can anyone point me in the right direction? |
Newbie : Advanced Filter Criteria
RM
Examples and instructions from Debra Dalgleish at http://www.contextures.on.ca/xladvfilter02.html You might also want to look at Pivot Tables for the manipulation of sales data. Take a peek at Debra's Pivot Table Tips. Link is on her tips page. http://www.contextures.on.ca/tiptech.html Gord Dibben Excel MVP - XL97 SR2 & XL2002 On Sat, 19 Jul 2003 17:07:57 GMT, "RM" wrote: I am using Excel 97. Our firm has a master spreadsheet that contains all sales information. The managers want me to create an easy to use form that can extract information from the spreadsheet. I wanted to use Advanced Filter Criteria. However, the help file is no help. Also, I can't seem to find good examples on the Internet. Can anyone point me in the right direction? |
All times are GMT +1. The time now is 02:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com