Sorting column into various worksheets by 'name'

[skyping]

Hi All,

I'm a bit stuck, so I hope that you guys can help me!

I have a spreadsheet, which has a master worksheet that will contain the names of (<100) opponents placed in column b. To the right of these names are a number of events which each one could enter.

I've then used a bit of code to register a tick along the corresponding rows if that particular opponent enters the corresponding 'event'.

Now the problem is that I would like to automatically fill the corresponding column in the other worksheets (which correspond to each event...I'm going to start each one in cell b3 to ease matters), with all the names of the opponents who wish to enter each competition.

I would then like to sort each of these generated columns in all worksheets alphabetically

I attach a demo if I've not explained myself too clearly!!

Hope you can help.

[Marcol]

Hi skyping

Try this out.

I've altered your code a little and added the code which allows you to add a competitor to the relative competition by ticking the table in Sheets("Master"), also if the competitor scratches then by unchecking he will be removed from the relevent sheet.

It's not bullet proof but should give you a good start.

Don't use filldown or multi delete the tick sheet I have not handled that situation.

Alistair

P.S.
I like that "trick" using Martlet to get a tick in a cell
Much better than using checkboxes

[skyping]

Hi Alistair,

Thanks for the prompt reply and excellent code.

I certainly will have a play with this, and once again thanks for your help!!

Kevin

[Marcol]

Hi skyping

Any problems you have with the code. Please feel free to ask.

Regards
Alistair

However

If that takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.