Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel Worksheet Tabs
I have created a grade book for the classes I teach at my local university. I
have been able to use many of the formula functions, etc. to automate much of the calculation and compilation work I need to do to get grades out. I have a tab for each student in a class. These worksheets auto populate the student's information when I copy the list into the first worksheet. With that as background, what I would like to have happen is for the tabs to also auto populate the student's name on the tab, as each worksheet is an individual student. Is there a way to set this up? Don Goss Frustrated Instructor |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel Worksheet Tabs
Gord, thank you for the response. I need to plead ignorant when it comes to
writing code. Do I place the information as a macro, or do I use it as a VBA command? Additionally, do I create the information as a cell on the first worksheet? Finally, can the list of names be in Column B? I appreciate the help Frustrated instructor "Gord Dibben" wrote: With a list of student names in first sheet in A1:A40 Sub NameWS() 'name sheets with list in Column A on first sheet On Error Resume Next For I = 2 To Worksheets.Count Sheets(I).Name = Sheets(1).Cells(I, 1).Value Next I End Sub Gord Dibben MS Excel MVP On Fri, 1 Aug 2008 07:01:01 -0700, Frustrated Instructor <Frustrated wrote: I have created a grade book for the classes I teach at my local university. I have been able to use many of the formula functions, etc. to automate much of the calculation and compilation work I need to do to get grades out. I have a tab for each student in a class. These worksheets auto populate the student's information when I copy the list into the first worksheet. With that as background, what I would like to have happen is for the tabs to also auto populate the student's name on the tab, as each worksheet is an individual student. Is there a way to set this up? Don Goss Frustrated Instructor |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel Worksheet Tabs
It is a macro and needs nothing more than copying to a module to be run.
See below for the How-to on storing and running. The student's names would be in Column B from B1 to wherever in Column B on your first worksheet. Say B1:B40 Here is revised code......................note the Cells(I, 2) denotes column(2) which is B Sub NameWS() 'name sheets with list in Column B on first sheet On Error Resume Next For I = 2 To Worksheets.Count Sheets(I).Name = Sheets(1).Cells(I, 2).Value Next I End Sub If you're not familiar with VBA and macros, see David McRitchie's site for more on "getting started". http://www.mvps.org/dmcritchie/excel/getstarted.htm or Ron de De Bruin's site on where to store macros. http://www.rondebruin.nl/code.htm In the meantime.......... First...create a backup copy of your original workbook. To create a General Module, hit ALT + F11 to open the Visual Basic Editor. Hit CRTL + r to open Project Explorer. Find your workbook/project and select it. Right-click and InsertModule. Paste the code in there. Save the workbook and hit ALT + Q to return to your workbook. Run or edit the macro by going to ToolMacroMacros. You can also assign this macro to a button or a shortcut key combo. Gord On Mon, 11 Aug 2008 14:08:03 -0700, Frustrated Instructor wrote: Gord, thank you for the response. I need to plead ignorant when it comes to writing code. Do I place the information as a macro, or do I use it as a VBA command? Additionally, do I create the information as a cell on the first worksheet? Finally, can the list of names be in Column B? I appreciate the help Frustrated instructor "Gord Dibben" wrote: With a list of student names in first sheet in A1:A40 Sub NameWS() 'name sheets with list in Column A on first sheet On Error Resume Next For I = 2 To Worksheets.Count Sheets(I).Name = Sheets(1).Cells(I, 1).Value Next I End Sub Gord Dibben MS Excel MVP On Fri, 1 Aug 2008 07:01:01 -0700, Frustrated Instructor <Frustrated wrote: I have created a grade book for the classes I teach at my local university. I have been able to use many of the formula functions, etc. to automate much of the calculation and compilation work I need to do to get grades out. I have a tab for each student in a class. These worksheets auto populate the student's information when I copy the list into the first worksheet. With that as background, what I would like to have happen is for the tabs to also auto populate the student's name on the tab, as each worksheet is an individual student. Is there a way to set this up? Don Goss Frustrated Instructor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost all my worksheet tabs on excel | Excel Worksheet Functions | |||
Can Excel worksheet tabs be relocated above the worksheet? | Excel Discussion (Misc queries) | |||
How do I format the tabs of a worksheet in Excel? | Excel Discussion (Misc queries) | |||
A "Document Map" of worksheet tabs for Excel | Setting up and Configuration of Excel | |||
Excel worksheet tabs | Excel Worksheet Functions |