Make copy of workbook based on selected criteria

A

Anthony

I have created a workbook that I use to create the team rosters for a
flag football league that currently has over 1100 kids and is getting
bigger. Currently, it contains two worksheets named Players and
RosterMaker. I have data validation in some of the cells on the
RosterMaker sheet which removes the player's name from the dropdown
list once it is chosen. The player's name is also removed from the
available players list on the roster maker page as a fail-safe for
me. I am currently looking to add a macro which would allow me to
choose the number of teams from 4-12, the number of players per team,
and create a copy of the master workbook for the selected values. I
would be happy to post a copy of the master workbook that I have
created. Can someone point me in the right direction?
 
D

Don Guillett

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 
A

Anthony

Don, how are you. This is SFC Anthony Saunders of the US Army. You
helped me before with the macro for a bowling handicap tracker. I
will send the file to you.
 
D

Don Guillett

I'm fine. You may recall that I was an Air Force brat and a former USAF
officer. I will be glad to help.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Don, how are you. This is SFC Anthony Saunders of the US Army. You
helped me before with the macro for a bowling handicap tracker. I
will send the file to you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top