Parsing out file into multiple new files

[ktalamantez]

I need to do this same thing (parse one file into multiple files). I copied the first macro and tried to use it in with my file, but get an error on -- Columns("C:C").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("AA1"), Unique:=True -- the error is "The extract range has a missing or illegal field name." Meaningful error to you?? Any idea how I can solve this? Thank you.


Moderator's Note: Moved from this thread, as per forum rules against taking over other people's threads.