I have a user with a request that I know I have seen done before but I
just can't find it on the internet.

The user has a master sheet with all the data. It has maybe 12 rows in
it. He wants to create sheets for each distinct value in column A and
have all the rows where the value of column A is the same be copied to
that specific sheet. I'm not really sure the best way to go about
doing this, although I could do something pretty ugly.

This is something that should be moved into a web app, which would
take about 10 minutes to throw together, but I do need this temporary
fix.

THanks

JOhn