Is there a way to auto sort and generate sheets?

**ccovemaker** · 12-29-2012, 04:01 AM

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.

**oeldere** · 12-29-2012, 04:05 AM

Probably I can't help you enough with your question.

You will need VBA for that.

You can start with posting an exel example, without confidentional information.

Please add also the desired result in you example.

**ccovemaker** · 12-29-2012, 04:28 AM

Ok I mocked up a Sample set of the question in the attached excel file.

The real worksheet has thousands of entries but the sample should convey the point.

I get the main worksheet then split it up based on the office.

I am wonder how I would set that up to automate this at all?