Macro not Creating Pivot Table anymore

B

bobbysmith

New Member
Joined
Jan 24, 2015
Messages
29
I have a Excel Template, the workbook has sheets named "Data " and "Pivot". The data I pull comes from a CSV file which i open as excel file which i copy and paste to the "DATA" sheet Column N. When i execute the macro it formats it the way i want it and dumps the pivottable to the "Pivot" sheet. Recently the macro formats it the way i want it BUT...it is not creating the Pivot table. I tried testing with the data i pulled from the past weeks and it works but it is not working for current week. I think it has to do with data in the CSV file. Below is the Code and Data. Any insight would be greatly appreciated.

Code:
Sub FormatData()
'Offline Activities Report
Dim lnglastrow As Long
Application.ScreenUpdating = False
lnglastrow = ThisWorkbook.Worksheets("Data").Range("n" & Rows.Count).End(xlUp).Row

Range("o1:o" & lnglastrow).Copy
Range("a1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("p1:p" & lnglastrow).Copy
Range("b1").PasteSpecial xlPasteValues
Range("s1:s" & lnglastrow).Copy
Range("c1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("w1:w" & lnglastrow).Copy
Range("d1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("d2:d" & lnglastrow).NumberFormat = "m/d/yyyy"
Range("y1:ac" & lnglastrow).Copy
Range("e1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("ae1:af" & lnglastrow).Copy
Range("j1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("l1").Select
Range("f2:g" & lnglastrow).NumberFormat = "h:mm"
Range("j1").Value = "Dept"
Range("k1").Value = "Site/Dept"
Range("a1:k1").HorizontalAlignment = xlCenter
Range("a1:a" & lnglastrow).RowHeight = 15
Range("a1:k1").Font.Bold = True

With ThisWorkbook.Worksheets("Data").Range("j1:j" & lnglastrow)
.Replace what:="WAU", replacement:="", lookat:=xlPart, searchorder:=xlByRows, MatchCase:=False
.Replace what:="CED", replacement:="", lookat:=xlPart, searchorder:=xlByRows, MatchCase:=False
.Replace what:="TUL", replacement:="", lookat:=xlPart, searchorder:=xlByRows, MatchCase:=False
.Replace what:="KNX", replacement:="", lookat:=xlPart, searchorder:=xlByRows, MatchCase:=False
End With

Range("a1:k1").AutoFilter
Range("a:k").Sort key1:=Range("f1"), order1:=xlAscending, Header:=xlYes
Range("a:h").EntireColumn.AutoFit
Range("j:k").EntireColumn.AutoFit
Range("a2").Select
ActiveWindow.FreezePanes = True
Range("N:AL").EntireColumn.ClearContents
Range("n1").Select
Sheets("Data").Buttons("button 1").Visible = False
Sheets("Data").Buttons("button 2").Visible = False

Range("n1").Select
With Selection.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With

Range("n1").ClearComments
Range("l1").Select

Range("m1").Value = "Team meeting Ct"
Range("f2:f" & lnglastrow).Copy
Range("m2").PasteSpecial xlPasteAll
Application.CutCopyMode = False
Range("m1").Font.Bold = True

Dim lnglastrow2 As Long
lnglastrow2 = ThisWorkbook.Worksheets("Data").Range("m" & Rows.Count).End(xlUp).Row
Range("m1:m" & lnglastrow2).RemoveDuplicates Columns:=Array(1), Header:=xlYes

Dim lnglastrow3 As Long
lnglastrow3 = ThisWorkbook.Worksheets("Data").Range("m" & Rows.Count).End(xlUp).Row
Range("n1").Value = " BUS SUPPT"
Range("o1").Value = " CUST SERV"
Range("p1").Value = " CUSTSERV HELP QUEUE"
Range("q1").Value = " CUSTSERV MULTI"
Range("r1").Value = " SOLUTIONS CONSULTANTS"
Range("s1").Value = " TECH SUPPT"
Range("t1").Value = " TELESALES"
Range("u1").Value = " WNP"
Range("n1:u1").Font.Bold = True

Range("n2").Formula = "=countifs($e:$e,""Team"",$j:$j,n$1,$f:$f,$m2)"
Range("n2").AutoFill Range("n2:u2"), xlFillDefault
Range("n2:u2").AutoFill Range("n2:u" & lnglastrow3), xlFillDefault

Range("n2:u" & lnglastrow3).Copy
Range("n2").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Range("l1").Select


Range("n2:u" & lnglastrow3).FormatConditions.Add xlCellValue, xlGreater, "=0"
Range("n2:u" & lnglastrow3).FormatConditions(Range("n2:u" & lnglastrow3).FormatConditions.Count). _
SetFirstPriority
With Range("n2:u" & lnglastrow3).FormatConditions(1).Font
.Bold = True
.Color = vbRed
.TintAndShade = 0
End With

Range("m:u").EntireColumn.AutoFit
Range("n2:u" & lnglastrow3).HorizontalAlignment = xlCenter
Range("l1").Select

Dim pvtC As PivotCache
Dim pvt As PivotTable
Dim pvtF As PivotField

On Error Resume Next
ThisWorkbook.Worksheets("Pivot").Select
ActiveSheet.PivotTables("pivottable1").TableRange2.Clear

ThisWorkbook.Worksheets("Data").Select
Set pvtC = ActiveWorkbook.PivotCaches.Create(xlDatabase, Range("a1:k" & lnglastrow))
Sheets("Pivot").Select
Set pvt = ActiveSheet.PivotTables.Add(pvtC, Range("a1"), "pivottable1")
With pvt

.PivotFields("Start_Date").Orientation = xlPageField
.PivotFields("Nom_Date").Orientation = xlPageField
.PivotFields("Dept").Orientation = xlRowField
.PivotFields("Seg_Code").Orientation = xlColumnField
.PivotFields("Emp_Sk").Orientation = xlDataField
.PivotFields("Sum of Emp_Sk").Function = xlCount
.DataBodyRange.NumberFormat = "#,0"
.ColumnGrand = False
.RowGrand = False
.CompactLayoutColumnHeader = "Offline"
.CompactLayoutRowHeader = "Offline Activities by Dept"
.ShowTableStyleRowStripes = True
.TableStyle2 = "pivotstylelight22"
.PivotFields("Offline Activities by Dept").AutoSort Order:=xlAscending
End With

Range("a3").EntireRow.Hidden = True
ActiveWorkbook.ShowPivotTableFieldList = False
Application.ScreenUpdating = True

End Sub

DATA: Columns (A:S)
[TABLE="width: 1634"]
<colgroup><col span="3"><col><col span="2"><col><col><col span="3"><col><col span="3"><col><col span="3"></colgroup><tbody>[TR]
[TD]PRI_INDEX[/TD]
[TD]EMP_SK[/TD]
[TD]EMP_ID[/TD]
[TD]EMP_LAST_NAME[/TD]
[TD]EMP_FIRST_NAME[/TD]
[TD]EMP_SORT_NAME[/TD]
[TD]EMP_SHORT_NAME[/TD]
[TD]EMP_SENIORITY[/TD]
[TD]EMP_EFF_HIRE_DATE[/TD]
[TD]NOM_DATE[/TD]
[TD]START_DATE[/TD]
[TD]SEG_CODE[/TD]
[TD]START_MOMENT[/TD]
[TD]STOP_MOMENT[/TD]
[TD]DURATION[/TD]
[TD]MEMO[/TD]
[TD]RANK[/TD]
[TD]EMP_CLASS_1[/TD]
[TD]EMP_CLASS_1_DESCR[/TD]
[/TR]
[TR]
[TD="align: right"]433[/TD]
[TD="align: right"]-9.9E+11[/TD]
[TD="align: right"]1[/TD]
[TD]DOE1[/TD]
[TD]JOE[/TD]
[TD]DOE1,JOE[/TD]
[TD]DOE1, JOE[/TD]
[TD="align: right"]20060619[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21

Steps to Complete Training

1. Go to Academy Point and click on the Register button in the top-right corner.

2. Enter the requested information and the User Registration Code “USCellular1031”

3. Complete the modules listed under “My Training Plan.”



[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]437[/TD]
[TD="align: right"]-9.9E+11[/TD]
[TD="align: right"]2[/TD]
[TD]DOE2[/TD]
[TD]JOE[/TD]
[TD]DOE2,JOE[/TD]
[TD]DOE2, JOE[/TD]
[TD="align: right"]20080107[/TD]
[TD="align: right"]1/7/2008[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21

Steps to Complete Training

1. Go to Academy Point and click on the Register button in the top-right corner.

2. Enter the requested information and the User Registration Code “USCellular1031”

3. Complete the modules listed under “My Training Plan.”



[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]253[/TD]
[TD="align: right"]-9.9E+11[/TD]
[TD="align: right"]3[/TD]
[TD]DOE3[/TD]
[TD]JOE[/TD]
[TD]DOE3,JOE[/TD]
[TD]DOE3, JOE[/TD]
[TD="align: right"]20170313[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]439[/TD]
[TD="align: right"]-9.9E+11[/TD]
[TD="align: right"]4[/TD]
[TD]DOE4[/TD]
[TD]JOE[/TD]
[TD]DOE4,JOE[/TD]
[TD]DOE4, JOE[/TD]
[TD="align: right"]20090622[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21

Steps to Complete Training

1. Go to Academy Point and click on the Register button in the top-right corner.

2. Enter the requested information and the User Registration Code “USCellular1031”

3. Complete the modules listed under “My Training Plan.”



[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]166[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]5[/TD]
[TD]DOE5[/TD]
[TD]JOE[/TD]
[TD]DOE5,JOE[/TD]
[TD]DOE5, JOE[/TD]
[TD="align: right"]20130930[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]KNX CUST SERV[/TD]
[TD]KNX CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]443[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]6[/TD]
[TD]DOE6[/TD]
[TD]JOE[/TD]
[TD]DOE6,JOE[/TD]
[TD]DOE6, JOE[/TD]
[TD="align: right"]20140310[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]446[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]7[/TD]
[TD]DOE7[/TD]
[TD]JOE[/TD]
[TD]DOE7,JOE[/TD]
[TD]DOE7, JOE[/TD]
[TD="align: right"]20160815[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]466[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]8[/TD]
[TD]DOE8[/TD]
[TD]JOE[/TD]
[TD]DOE8,JOE[/TD]
[TD]DOE8, JOE[/TD]
[TD="align: right"]20140707[/TD]
[TD="align: right"]7/7/2014[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[/TR]
[TR]
[TD="align: right"]447[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]9[/TD]
[TD]DOE9[/TD]
[TD]JOE[/TD]
[TD]DOE9,JOE[/TD]
[TD]DOE9, JOE[/TD]
[TD="align: right"]20140915[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21

Steps to Complete Training

1. Go to Academy Point and click on the Register button in the top-right corner.

2. Enter the requested information and the User Registration Code “USCellular1031”

3. Complete the modules listed under “My Training Plan.”



[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]374[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]10[/TD]
[TD]DOE10[/TD]
[TD]JOE[/TD]
[TD]DOE10,JOE[/TD]
[TD]DOE10, JOE[/TD]
[TD="align: right"]20140915[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUST SERV[/TD]
[TD]WAU CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]468[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]11[/TD]
[TD]DOE11[/TD]
[TD]JOE[/TD]
[TD]DOE11,JOE[/TD]
[TD]DOE11, JOE[/TD]
[TD="align: right"]20141124[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[/TR]
[TR]
[TD="align: right"]470[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]12[/TD]
[TD]DOE12[/TD]
[TD]JOE[/TD]
[TD]DOE12,JOE[/TD]
[TD]DOE12, JOE[/TD]
[TD="align: right"]20150112[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[/TR]
[TR]
[TD="align: right"]450[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]13[/TD]
[TD]DOE13[/TD]
[TD]JOE[/TD]
[TD]DOE13,JOE[/TD]
[TD]DOE13, JOE[/TD]
[TD="align: right"]20160815[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]452[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]14[/TD]
[TD]DOE14[/TD]
[TD]JOE[/TD]
[TD]DOE14,JOE[/TD]
[TD]DOE14, JOE[/TD]
[TD="align: right"]20151005[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]454[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]15[/TD]
[TD]DOE15[/TD]
[TD]JOE[/TD]
[TD]DOE15,JOE[/TD]
[TD]DOE15, JOE[/TD]
[TD="align: right"]20121217[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21

Steps to Complete Training

1. Go to Academy Point and click on the Register button in the top-right corner.

2. Enter the requested information and the User Registration Code “USCellular1031”

3. Complete the modules listed under “My Training Plan.”



[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]456[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]16[/TD]
[TD]DOE16[/TD]
[TD]JOE[/TD]
[TD]DOE16,JOE[/TD]
[TD]DOE16, JOE[/TD]
[TD="align: right"]20160523[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21

Steps to Complete Training

1. Go to Academy Point and click on the Register button in the top-right corner.

2. Enter the requested information and the User Registration Code “USCellular1031”

3. Complete the modules listed under “My Training Plan.”



[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]290[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]17[/TD]
[TD]DOE17[/TD]
[TD]JOE[/TD]
[TD]DOE17,JOE[/TD]
[TD]DOE17, JOE[/TD]
[TD="align: right"]20160718[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]458[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]18[/TD]
[TD]DOE18[/TD]
[TD]JOE[/TD]
[TD]DOE18,JOE[/TD]
[TD]DOE18, JOE[/TD]
[TD="align: right"]20160815[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21

Steps to Complete Training

1. Go to Academy Point and click on the Register button in the top-right corner.

2. Enter the requested information and the User Registration Code “USCellular1031”

3. Complete the modules listed under “My Training Plan.”



[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]460[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]19[/TD]
[TD]DOE19[/TD]
[TD]JOE[/TD]
[TD]DOE19,JOE[/TD]
[TD]DOE19, JOE[/TD]
[TD="align: right"]20160815[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21

Steps to Complete Training

1. Go to Academy Point and click on the Register button in the top-right corner.

2. Enter the requested information and the User Registration Code “USCellular1031”

3. Complete the modules listed under “My Training Plan.”



[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]463[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]20[/TD]
[TD]DOE20[/TD]
[TD]JOE[/TD]
[TD]DOE20,JOE[/TD]
[TD]DOE20, JOE[/TD]
[TD="align: right"]20160815[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Tech 21

Steps to Complete Training

1. Go to Academy Point and click on the Register button in the top-right corner.

2. Enter the requested information and the User Registration Code “USCellular1031”

3. Complete the modules listed under “My Training Plan.”



[/TD]
[TD="align: right"]54[/TD]
[TD]TUL TELESALES[/TD]
[TD]TUL TELESALES[/TD]
[/TR]
[TR]
[TD="align: right"]471[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]21[/TD]
[TD]DOE21[/TD]
[TD]JOE[/TD]
[TD]DOE21,JOE[/TD]
[TD]DOE21, JOE[/TD]
[TD="align: right"]20160912[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[TD]WAU CUSTSERV MULTI[/TD]
[/TR]
[TR]
[TD="align: right"]176[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]22[/TD]
[TD]DOE22[/TD]
[TD]JOE[/TD]
[TD]DOE22,JOE[/TD]
[TD]DOE22, JOE[/TD]
[TD="align: right"]20161031[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]KNX CUST SERV[/TD]
[TD]KNX CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]293[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]23[/TD]
[TD]DOE23[/TD]
[TD]JOE[/TD]
[TD]DOE23,JOE[/TD]
[TD]DOE23, JOE[/TD]
[TD="align: right"]20160926[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]295[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]24[/TD]
[TD]DOE24[/TD]
[TD]JOE[/TD]
[TD]DOE24,JOE[/TD]
[TD]DOE24, JOE[/TD]
[TD="align: right"]20160926[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]296[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]25[/TD]
[TD]DOE25[/TD]
[TD]JOE[/TD]
[TD]DOE25,JOE[/TD]
[TD]DOE25, JOE[/TD]
[TD="align: right"]20160926[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]177[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]26[/TD]
[TD]DOE26[/TD]
[TD]JOE[/TD]
[TD]DOE26,JOE[/TD]
[TD]DOE26, JOE[/TD]
[TD="align: right"]20161031[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]KNX CUST SERV[/TD]
[TD]KNX CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]308[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]27[/TD]
[TD]DOE27[/TD]
[TD]JOE[/TD]
[TD]DOE27,JOE[/TD]
[TD]DOE27, JOE[/TD]
[TD="align: right"]20161205[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]313[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]28[/TD]
[TD]DOE28[/TD]
[TD]JOE[/TD]
[TD]DOE28,JOE[/TD]
[TD]DOE28, JOE[/TD]
[TD="align: right"]20170116[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]316[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]29[/TD]
[TD]DOE29[/TD]
[TD]JOE[/TD]
[TD]DOE29,JOE[/TD]
[TD]DOE29, JOE[/TD]
[TD="align: right"]20170116[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]321[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]30[/TD]
[TD]DOE30[/TD]
[TD]JOE[/TD]
[TD]DOE30,JOE[/TD]
[TD]DOE30, JOE[/TD]
[TD="align: right"]20170313[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]328[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]31[/TD]
[TD]DOE31[/TD]
[TD]JOE[/TD]
[TD]DOE31,JOE[/TD]
[TD]DOE31, JOE[/TD]
[TD="align: right"]20170313[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]332[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]32[/TD]
[TD]DOE32[/TD]
[TD]JOE[/TD]
[TD]DOE32,JOE[/TD]
[TD]DOE32, JOE[/TD]
[TD="align: right"]20170313[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]TUL CUST SERV[/TD]
[TD]TUL CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]180[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]33[/TD]
[TD]DOE33[/TD]
[TD]JOE[/TD]
[TD]DOE33,JOE[/TD]
[TD]DOE33, JOE[/TD]
[TD="align: right"]20161107[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]KNX CUST SERV[/TD]
[TD]KNX CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]181[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]34[/TD]
[TD]DOE34[/TD]
[TD]JOE[/TD]
[TD]DOE34,JOE[/TD]
[TD]DOE34, JOE[/TD]
[TD="align: right"]20170424[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]KNX CUST SERV[/TD]
[TD]KNX CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]413[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]35[/TD]
[TD]DOE35[/TD]
[TD]JOE[/TD]
[TD]DOE35,JOE[/TD]
[TD]DOE35, JOE[/TD]
[TD="align: right"]20170508[/TD]
[TD="align: right"]5/8/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUST SERV[/TD]
[TD]WAU CUST SERV[/TD]
[/TR]
[TR]
[TD="align: right"]419[/TD]
[TD="align: right"]-9.6E+11[/TD]
[TD="align: right"]36[/TD]
[TD]DOE36[/TD]
[TD]JOE[/TD]
[TD]DOE36,JOE[/TD]
[TD]DOE36, JOE[/TD]
[TD="align: right"]20170508[/TD]
[TD="align: right"]5/8/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD="align: right"]8/2/2017[/TD]
[TD]CBT[/TD]
[TD="align: center"]########[/TD]
[TD="align: center"]########[/TD]
[TD="align: right"]10[/TD]
[TD]Go to tech21training and click Register in the top-right corner. Complete registration using for the User Registration Code. Sign-in when prompted and then scroll down and complete the 3 modules listed under My Training Plan.[/TD]
[TD="align: right"]54[/TD]
[TD]WAU CUST SERV[/TD]
[TD]WAU CUST SERV[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
You must log in or register to reply here.

Forum statistics

Threads
1,223,897
Messages
6,175,270
Members
452,628
Latest member
dd2

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top