Debra Dalgleish and Ron de Bruin have samples that you may like. Ron's addin
may be sufficient right out of the box.

Debra's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

or

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

And Ron de Bruin's easyfilter.
http://www.rondebruin.nl/easyfilter.htm

TimezZ wrote:

i have a prob with some tab delimited files and excel... is there a way
i can import them into the excel then sort them to different sheets
base on the name column? the tab delimited files do not have a header.

for ex in the tab delimited files..
01/01/01 01:01:01 Name1 IN
01/01/01 01:01:05 Name2 IN
01/01/01 01:01:10 Name2 OUT
01/01/01 01:01:15 Name1 OUT

--
TimezZ
------------------------------------------------------------------------
TimezZ's Profile: http://www.excelforum.com/member.php...o&userid=31081
View this thread: http://www.excelforum.com/showthread...hreadid=507567

--

Dave Peterson