Hello All,

I am not an Excel pro and I was wondering if it was possible to have Excel sort and then Auto generate a work sheet.


Once a week at work I get a report that is split up via our 3 digit office codes.

Once a week I manually sort the info and split the original sheet into separate sheets based on the office code and mail it to them.


Is there a tool, function, or wizard I am missing that would help automating this some?

Its is simple and repetitive but takes me half a day to do due to the size.

Any help is welcome.

Thanks.