the sheet already exists and is in the same basic order and i just want to
have the sheet renamed to match the name on the roster

"Zone" wrote:

locke, the solution depends on whether the worksheet for player one's stats
already exists and always resides in the same order within the worksheets
(and you just want to rename that sheet), or whether you want to create a
new sheet for Player One. James

"locke1990" wrote in message
...
ok, i have a spreadsheet with about 50 worksheets. the first 20 or so are
individual games with stats. the next 20-25 are for individual player
stats.
the final few pages are things like schedule, roster, team stats, etc.

What i am trying to do is: when i fill in the roster, lets say A1 on the
roster is named Player One. I want whatever I put in A1 to be the name of
the worksheet for Player One's stats. Hope this helps.

"Zone" wrote:

Do you mean you want to save the individual worksheet in a new file named
according to the name of the worksheet?

"locke1990" wrote in message
...
I have several worksheets that I use for team stats. I want to be able
to
take the name off my roster sheet and use it as a name for the players
individual stats sheet. Is this possible? How?