So you essentially want to filter a list, and copy the filtered result somewhere else? If so, you can use the advanced filter for that.
If you have excel 2010, here's an example of how to do it:
1. type the word Symbol in H1
2. in H2 put the particular text string that you want to filter on. For instance, MBSL.N0000`N
3. From the Data tab, select Advanced.
4. Select "Copy to another location"
5.Input your list range into the 'List range' box i.e. $A$1:$E$2183 in your example file
6. For the criteria range, select $H$1:$H$2
7. For the Copy To range, select where you want the files returned to
8. Push Ok
A google search will give you more info. Or check out these links:
http://www.tushar-mehta.com/publish_...lysis/06.shtml
http://dailydoseofexcel.com/archives...tering-in-vba/ (in case you want to automate this)
http://www.excelhero.com/blog/2010/0...se-lookup.html has a couple of ways you can do this, with an Advanced Filter (read through the post until you get to the --- UPDATE --- bit that talks about an approach by Sam, and has a link to a workbook here:
http://www.excelhero.com/blog/workbo...elhero.com.xls
Bookmarks