Can't you just use datafilterautofilter to work with it as is?

If you insist. As has been suggested by Joel, I would use advanced filter to
make a unique listdo a for each loop for each item in the unique list to
filter the sheet and then copy the visible to a new wb.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"George" wrote in message
...
Dear group members,

My need is to parse Excel file.
I have names of departments in F column:

aa
ab
ac
df
(et cetera, 30 departments)

I have list of departments and other information in my source Excel
file.
My task is:
1) copy three first lines of sheet "as is"
2) copy all strings with "aa" in F column,
3) paste to other Excel file and to save it as C:\destination\aa.xls

Then to do the same for "ab", "ac" and all the rest 30 departments.

Tell me please how do I perform this.
Thank you.