| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I FILTER this?
Hi, I am working with 2 workbooks. The first workbook has a list of worksheets in alphabetical order by last name, for example: "Anderson", "Casey", "Lee", etc. The second workbook has a sheet with a list of names as well as their account numbers, descriptions and end dates. However, each person has several account numbers, and the names in this workbook includes the Last Name as well as the First Initial. For example, "Anderson M", "Lee, F", etc. How can I get vba to sort it so that I can filter out the names and copy the necessary rows to their respective sheets in workbook1? Desperately in need of help. Thanks in advance! -- Sethaholic ------------------------------------------------------------------------ Sethaholic's Profile: http://www.excelforum.com/member.php...o&userid=25113 View this thread: http://www.excelforum.com/showthread...hreadid=386538 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
| filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
| Advance filter search does not filter an exact match | Excel Programming | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| How to set multiple filter values for a filter in the page fields | Excel Programming | |||
![Sethaholic[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
