Ok I got a situation here and need an expert to share their expertise.
I have a giant table of data in MS Excel, looks like:
Name | Status | email | Office Code
It is very long. I need to divide this list up, by Office Code, into separate worksheets (so that each Office Code, which contains maybe 20 people, has its own separate worksheet)
Is there some way to Automatically do this?