Excel Sheet tab names

[Carl]

I am making a program in excel for some time cards then workbook starts with
sheet one to change the date next sheet has the list of names with all the
info that needs to be put on the timesheet that lists all the names in
alphabetical order and the sheet that follow are the timecards i can get it
to put all the info itto the sheet but what i need to do is get the sheet
name tab to change to what the name from the list is so the tab names changes
as the list changes can someone help please.

 

[Moovysheek]

Did you proof read this before posting? Can you use periods please? I do not
understand where or what your question is.

 

[Fred Smith]

Your question is not understandable. Before you post again, ask a friend to
review it for clarity. Once you ask a clear question on this board, you will
get accurate solutions very quickly.

Regards,
Fred

 

[StickThatInYourPipeAndSmokeIt]

All gang boy retard mentalities need to be ignored until the stupid
twits wake up to reality. Instead of letting these idiots manipulate our
reality, we need to FORCE them to wake the hell up, and live in OUR civil
reality.

So, yeah, even non-gang boy idiots that nonetheless embrace the gang boy
mentality world, should ALSO be ignored until they wise the hell up!

I am surprised the that word "I" got capitalized. And no, he does not
even know what the word "proofread" means because he has never done such
a thing before he posts his utter crap.

Oh boy.... he said please.

So I ask...

Please refrain from the NOT "modern" gang boy lingo. ACT like a
professional, and you will get treated like one.

Let me guess... BOTH tattoos AND body piercings?

This entire planet has become pathetic. No wonder Jesus is coming back
to judge us all. Everyone wants to ride the damned fence. It doesn't
work.

 

[StickThatInYourPipeAndSmokeIt]

I was not nearly so diplomatic.

Your question is not understandable. Before you post again, ask a friend to
review it for clarity. Once you ask a clear question on this board, you will
get accurate solutions very quickly.

Regards,
Fred

 

[Fred Smith]

I don't consider "gang boy retard mentalities" and "stupid twits" to be
"civil reality".

You need to follow your own advice.

Regards,
Fred

 

[StickThatInYourPipeAndSmokeIt]

No, asshole, ALL of the civil community needs to make a stand against
the stupidity.

One day, after it is too late, you might realize this. The world needs
a drill Sgt. Sorry the truth hurts, but it is, nonetheless, the truth.

We need a federally mandated death penalty to override pathetic
sympathetic to the criminal states that no longer punish appropriately.

ALL gun and knife crimes should result in life without parole and never
stepping on free soil again. All crimes that result in death should
result in a death sentence.

ALL gang members need to be rounded up and put on chain gangs to build
the prisons that this country has lacked on for so long. Every goddamned
one of them commits crimes just to get in the gang, and that is good
enough reason to me for NOT giving the retarded bastards ANY
constitutional rights. The constitution allows PEACIBLE assembly, NOT
the CRAP that they push into society. Complacent fucking utter retards
like you are why they are STILL here! THAT is UNACCEPTABLE. Dig?

Currently we waste billions of tax payer dollars convicting these
bastards, then we let them right back out, all the while charging "costs"
against the state and federal funds for incarceration. You have no
fucking clue how much is wasted.

For that, I say that the idiots running the show need to be executed
(read fired), because they are wasting our money and NOT getting the
fucking job done.

So YOU need to learn how to measure advice. This country needs to
realize that complacency is NOT a solution. Maybe one day when your kid
is affected by the profiling pigs that have resulted from this or by one
of the criminals themselves, maybe then you will get a fucking clue, you
fucking yahoo.

 

[Stan Brown]

Sun, 28 Feb 2010 05:11:01 -0800 from Carl

I am making a program in excel for some time cards then workbook starts with
sheet one to change the date next sheet has the list of names with all the
info that needs to be put on the timesheet that lists all the names in
alphabetical order and the sheet that follow are the timecards i can get it
to put all the info itto the sheet but what i need to do is get the sheet
name tab to change to what the name from the list is so the tab names changes
as the list changes can someone help please.

I fell asleep several lines into that sentence. Also, your Shift
keys seem to be broken.

 

[Dave Peterson]

First, I find this kind of stuff very dangerous. Too many things can contribute
to break the process. For instance, if you move a sheet, then it may get
renamed incorrectly.

But if you want, you could run a routine like this.

It assumes that the first sheet (leftmost) shouldn't be touched.
The second sheet (2nd from the left) contains the names in a1:Axx
And the 3rd (and the rest) should be named in that order.

Option Explicit
Sub testme()
Dim myRng As Range
Dim myCell As Range
Dim wCtr As Long
Dim HowManyNames As Long

With Sheets(2) 'second position!
Set myRng = .Range("a1", .Cells(.Rows.Count, "A").End(xlUp))
End With

HowManyNames = myRng.Cells.Count

If HowManyNames <> ActiveWorkbook.Sheets.Count - 2 Then
MsgBox "the number of names doesn't match the number of sheets!"
Exit Sub
End If

wCtr = 3 'since we want to start with the 3rd sheet
For Each myCell In myRng.Cells
On Error Resume Next
Sheets(wCtr).Name = myCell.Value
If Err.Number <> 0 Then
Err.Clear
MsgBox "Error renaming the sheets"
Exit Sub
End If
On Error GoTo 0
wCtr = wCtr + 1
Next myCell

End Sub

You'll type in the names and then run the macro. If the list changes, you'll
have to rerun the macro.



If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

 

[Bill]

First, I find this kind of stuff very dangerous. Too many things can contribute
to break the process. For instance, if you move a sheet, then it may get
renamed incorrectly.

But if you want, you could run a routine like this.

It assumes that the first sheet (leftmost) shouldn't be touched.
The second sheet (2nd from the left) contains the names in a1:Axx
And the 3rd (and the rest) should be named in that order.

Option Explicit
Sub testme()
Dim myRng As Range
Dim myCell As Range
Dim wCtr As Long
Dim HowManyNames As Long

With Sheets(2) 'second position!
Set myRng = .Range("a1", .Cells(.Rows.Count, "A").End(xlUp))
End With

HowManyNames = myRng.Cells.Count

If HowManyNames<> ActiveWorkbook.Sheets.Count - 2 Then
MsgBox "the number of names doesn't match the number of sheets!"
Exit Sub
End If

wCtr = 3 'since we want to start with the 3rd sheet
For Each myCell In myRng.Cells
On Error Resume Next
Sheets(wCtr).Name = myCell.Value
If Err.Number<> 0 Then
Err.Clear
MsgBox "Error renaming the sheets"
Exit Sub
End If
On Error GoTo 0
wCtr = wCtr + 1
Next myCell

End Sub

You'll type in the names and then run the macro. If the list changes, you'll
have to rerun the macro.



If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Thanks, Dave, for trying to answer the guy's questions and giving him
some links to macro creation.

Bill

 

[StickThatInYourPipeAndSmokeIt]

Thanks, Dave, for trying to answer the guy's questions and giving him
some links to macro creation.

Bill

You forgot to leave out the punctuation, punk. He won't be able to
read that.

 

[Dave Peterson]

You're welcome, Bill.

Maybe it'll help. But I still don't like this kind of macro <vbg>.

 

[John]

Good Man, Dave
At least one person is trying to help.
Regards
John

 

[Son of a Sea Cook]

Pathetic trivialization of those we should ignore completely until they
shape up.

You know... "shipped out" Until conformity occurs.

YOU are part of the problem with your pathetic tolerance.

Note that the OP hasn't replied back to anyone. Looks like the taser
shot might have worked.

Goddamned texting tools on phones exacerbate this retarded NON-English
El Stupido Retardo mentality. Slacker society will fail miserably.

Thanks for contributing to the stupidity, or tolerance thereof. NOT!

 

[Billns]

Pathetic trivialization of those we should ignore completely until they
shape up.

You know... "shipped out" Until conformity occurs.

YOU are part of the problem with your pathetic tolerance.

Note that the OP hasn't replied back to anyone. Looks like the taser
shot might have worked.

Goddamned texting tools on phones exacerbate this retarded NON-English
El Stupido Retardo mentality. Slacker society will fail miserably.

Thanks for contributing to the stupidity, or tolerance thereof. NOT!

Type A personality gone wild!

Bill

 

[John]

Hi Bill
Does Type A stand for "Asshole".... LoL
I think he's just narrow minded.
1- Having or showing a prejudiced mind, as persons or opinions; biased.
2- Not receptive to new ideas; having a closed mind.
3- Extremely conservative and morally self-righteous.

Have a good day
John