how to put cell information as filename
 

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?

how to put cell information as filename
 

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?

how to put cell information as filename
 

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?

how to put cell information as filename
 

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?

how to put cell information as filename
 

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?

how to put cell information as filename
 

Say you want to name your second worksheet with the value in cell A1, the
third worksheet with the value in A2, and so on. Copy this code and paste
it in a standard module:

Sub NameShts()
With ThisWorkbook
.Worksheets(2).Name = [a1]
.Worksheets(3).Name = [a2]
End With
End Sub

Or, say you have 20 names in column A and you want to name the sheets
beginning with the 5th sheet after those 20 names, use something like this
instead:
..
Sub NameShtsA()
With ThisWorkbook
For k=1 to 20
.Worksheets(5+k).Name = cells(k,"a")
Next k
End With
End Sub

Be sure you are on the worksheet with the name list when you run the macro.
If you have a blank cell in one of the 20 cells, you'll get an error. If
there are more names than sheets, you'll get an error.
HTH, James

"locke1990" wrote in message
...
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?

thanks
 

finally....i've been trying to do this now for 3 years. i've been manually
changing all the page names each year and for each sport.

thanks very much, with a little manipulation, its working wonderfully

thanks
 

Great! Thanks for the feedback. James
"locke1990" wrote in message
...
finally....i've been trying to do this now for 3 years. i've been
manually
changing all the page names each year and for each sport.

thanks very much, with a little manipulation, its working wonderfully