Macro: Filter Multiple header then extract to Multiple Files
Help!!!
I came accross several post pertaining to autofiltering and extracting
to different sheets, However, What I need to do is this:
Having a File with 6 lin Header
(Company Name, Project Name, Document Name, Date, then Column Labels)
I have the rep number on Column "A" starting at "A7"
I have to compile the records of each rep to one file (not sheet) then
get the total for each sheet at the bottom.
Any help will be greatly appreciated.
Niegel
|