Career Coach EZ lift is the process created and administered by Enabling Services.
...
#6. Details on creating worksheet tabs are here (click on the hyperlink-#6)
7Enabling #7. Academic Programs and occupations associated with them
8Enabling Services finds Occupation Codes/Occupation Titles aligning with academic programs, adding them to each program worksheet
8Enabling 9Enabling Services sends EZ Lift workbook to school for review
9School 10School disseminates worksheets (one for each academic program) to Deans/Department Chairs responsible for assigned disciplines and their associated academic programs.
10Deans11Deans/Department Chairs review worksheets for their discipline, reviewing Occupation Codes/Titles Enabling Services assigned to each program; they may choose to ‘strike’ some of the Occupation Codes/Titles assigned.
11School 12School returns updated EZ Lift workbook to Enabling Services
12Enabling 13Enabling Services adds approved Occupation Codes/Occupation Titles to Occupation Mappings worksheet, program by program - within Career Coach workbook (as updated/received by school in item 4)
13Enabling 14Enabling Services sends updated Career Coach workbook to Lightcast
14Lightcast 15Lightcast makes updates in Career Coach, and sends updated workbook to Enabling Services
15Enabling 16Enabling Services delivers updated workbook to school
...
Sub AddSheets()
'Updateby Extendoffice
Dim xRg As Excel.Range
Dim wSh As Excel.Worksheet
Dim wBk As Excel.Workbook
Set wSh = ActiveSheet
Set wBk = ActiveWorkbook
Application.ScreenUpdating = False
For Each xRg In wSh.Range("A1:A7")
With wBk
.Sheets.Add after:=.Sheets(.Sheets.Count)
On Error Resume Next
ActiveSheet.Name = xRg.Value
If Err.Number = 1004 Then
Debug.Print xRg.Value & " already used as a sheet name"
End If
On Error GoTo 0
End With
Next xRg
Application.ScreenUpdating = True
End Sub
...
Freeze the top row (View tab, Freeze Panes, Freeze top row).
| Anchor | ||||
|---|---|---|---|---|
|
Sometimes you have to ‘think outside the box’. What’s a similar name for a program?
...