Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheet tab names
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheet tab names
Did you proof read this before posting? Can you use periods please? I do not
understand where or what your question is. "Carl" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheet tab names
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 "Carl" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheet tab names
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. On Sun, 28 Feb 2010 07:23:02 -0800, Moovysheek wrote: Did you proof read this before posting? Can you use periods please? I do not understand where or what your question is. "Carl" wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheet tab names
I was not nearly so diplomatic.
On Sun, 28 Feb 2010 08:55:15 -0700, "Fred Smith" wrote: 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 "Carl" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheet tab names
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" wrote in message ... 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. On Sun, 28 Feb 2010 07:23:02 -0800, Moovysheek wrote: Did you proof read this before posting? Can you use periods please? I do not understand where or what your question is. "Carl" wrote: 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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheet tab names
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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheet tab names
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 he 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.) Carl wrote: 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. -- Dave Peterson |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheet tab names
On 2/28/2010 10:13 AM, Dave Peterson wrote:
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 he 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.) Carl wrote: 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. Thanks, Dave, for trying to answer the guy's questions and giving him some links to macro creation. Bill |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheet tab names
On Sun, 28 Feb 2010 12:55:04 -0800, Bill wrote:
On 2/28/2010 10:13 AM, Dave Peterson wrote: 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 he 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.) Carl wrote: 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. 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. |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheet tab names
You're welcome, Bill.
Maybe it'll help. But I still don't like this kind of macro <vbg. Bill wrote: On 2/28/2010 10:13 AM, Dave Peterson wrote: 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 he 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.) Carl wrote: 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. Thanks, Dave, for trying to answer the guy's questions and giving him some links to macro creation. Bill -- Dave Peterson |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheet tab names
Good Man, Dave
At least one person is trying to help. Regards John "Dave Peterson" wrote in message ... 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 he 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.) Carl wrote: 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. -- Dave Peterson |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheet tab names
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! |
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheet tab names
On 2/28/2010 6:46 PM, Son of a Sea Cook wrote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel sheet names | Excel Discussion (Misc queries) | |||
how do I arrange names in alphabetic order in an excel sheet | Excel Discussion (Misc queries) | |||
Cell names = sheet names | Excel Worksheet Functions | |||
Copying a sheet with a chart that uses Excel Names | Charts and Charting in Excel | |||
Function to List an Excel Workbook's Sheet Names | Excel Discussion (Misc queries) |