tommybone30
New Member
- Joined
- Dec 14, 2017
- Messages
- 14
Hello, I really need some help!
Keep in mind that I use the Record Macro function liberally, so this may have to do with my limited knowledge of actual coding procedures. But here goes my explanation:
In Macro Excel VBA, I've coded into VBA the formulas of SUMIFS functions for each column listed below ("Basic Life", "Voluntary Life", "Voluntary Spouse Life", etc.); the Total column is computed using the SUM formula. The SUMIFS formula is written as:
=SUMIFS('Basic Life'!L:L, 'Basic Life'!F:F,Match!B70,'Basic Life'!I:I,Match!C70)*2
The other columns are essentially written with the similar formula, just with a different worksheet name (e.g. instead of 'Basic Life', it's 'Voluntary Life', and the next column 'Voluntary Spouse Life', etc.).
I then coded the copy and paste formulas to have it computed to the appropriate rows (as can be seen below).
However, when the Macro computed the code, while everything else seems fine, the formula I've written for each cell that contains the "$ -" do not automatically compute to what's in the other worksheets. I've been trying to get it to work, but it always seems to draw blank, even though there are data in the other worksheets. Any ideas what I may be doing wrong?
I hope the visual aids below will give you better insight into my coding problems.
Here's the code:
Range("D5").Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS('Basic Life'!C[8], 'Basic Life'!C[2],Match!RC[-2],'Basic Life'!C[5],Match!RC[-1])*2"
Range("E5").Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS('Voluntary Life'!C[7],'Voluntary Life'!C[1],Match!RC[-3],'Voluntary Life'!C[4],Match!RC[-2])*2"
Range("F5").Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS('Voluntary SP Life'!C[6],'Voluntary SP Life'!C,Match!RC[-4],'Voluntary SP Life'!C[3],Match!RC[-3])*2"
Range("G5").Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS('Voluntary CH Life'!C[4],'Voluntary CH Life'!C[-1],Match!RC[-5],'Voluntary CH Life'!C[2],Match!RC[-4])*2"
Range("H5").Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS(LTD!C[4],LTD!C[-2],Match!RC[-6],LTD!C[1],Match!RC[-5])*2"
Range("I5").Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS('Basic AD&D'!C[3],'Basic AD&D'!C[-3],Match!RC[-7],'Basic AD&D'!C,Match!RC[-6])*2"
Range("J5").Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS(STD!C[2],STD!C[-4],Match!RC[-8],STD!C[-1],Match!RC[-7])*2"
Range("K5").Select
ActiveCell.FormulaR1C1 = "=SUM(RC[-7]:RC[-1])"
Range("D5:K5").Select
Selection.Copy
Range("D5:K25").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("M13").Select
Application.CutCopyMode = False
Range("D25:K25").Select
Selection.Copy
Range("D28:K29").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("D32:K34").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("D37:K56").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("D59:K66").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("D69:K97").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
And here's the computed Excel based on that code:
[TABLE="width: 630"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"]Div
[/TD]
[TD="class: xl70, width: 200, bgcolor: transparent"]Department
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Basic Life
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Voluntary Life
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Voluntary Spouse Life
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Voluntary Child Life
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Long Term Disability
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Basic AD&D
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Short Term Disability
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Total
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Admin
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]AWG
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Client Services
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]DVS
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]5
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Executive Management
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Finance
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Finance Payroll
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Frontline
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]HR
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Non ED IQ
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]IT
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]12
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Legal
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]13
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Management
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]14
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Marketing
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]15
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Ops Admin
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]16
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]PMO
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]17
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Procurement
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]18
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]QA
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]19
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Rehab
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]20
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Rehab Management
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]21
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Sales & Marketing
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]22
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACTH
[/TD]
[TD="class: xl66, bgcolor: transparent"]Admin
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]23
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACTH
[/TD]
[TD="class: xl66, bgcolor: transparent"]Executive Management
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]24
[/TD]
[TD="class: xl65, bgcolor: transparent"]CHR
[/TD]
[TD="class: xl66, bgcolor: transparent"]Bad Debt
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]25
[/TD]
[TD="class: xl65, bgcolor: transparent"]CHR
[/TD]
[TD="class: xl66, bgcolor: transparent"]Executive 5010
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]26
[/TD]
[TD="class: xl65, bgcolor: transparent"]CHR
[/TD]
[TD="class: xl66, bgcolor: transparent"]Facility 5114
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
Keep in mind that I use the Record Macro function liberally, so this may have to do with my limited knowledge of actual coding procedures. But here goes my explanation:
In Macro Excel VBA, I've coded into VBA the formulas of SUMIFS functions for each column listed below ("Basic Life", "Voluntary Life", "Voluntary Spouse Life", etc.); the Total column is computed using the SUM formula. The SUMIFS formula is written as:
=SUMIFS('Basic Life'!L:L, 'Basic Life'!F:F,Match!B70,'Basic Life'!I:I,Match!C70)*2
The other columns are essentially written with the similar formula, just with a different worksheet name (e.g. instead of 'Basic Life', it's 'Voluntary Life', and the next column 'Voluntary Spouse Life', etc.).
I then coded the copy and paste formulas to have it computed to the appropriate rows (as can be seen below).
However, when the Macro computed the code, while everything else seems fine, the formula I've written for each cell that contains the "$ -" do not automatically compute to what's in the other worksheets. I've been trying to get it to work, but it always seems to draw blank, even though there are data in the other worksheets. Any ideas what I may be doing wrong?
I hope the visual aids below will give you better insight into my coding problems.
Here's the code:
Range("D5").Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS('Basic Life'!C[8], 'Basic Life'!C[2],Match!RC[-2],'Basic Life'!C[5],Match!RC[-1])*2"
Range("E5").Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS('Voluntary Life'!C[7],'Voluntary Life'!C[1],Match!RC[-3],'Voluntary Life'!C[4],Match!RC[-2])*2"
Range("F5").Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS('Voluntary SP Life'!C[6],'Voluntary SP Life'!C,Match!RC[-4],'Voluntary SP Life'!C[3],Match!RC[-3])*2"
Range("G5").Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS('Voluntary CH Life'!C[4],'Voluntary CH Life'!C[-1],Match!RC[-5],'Voluntary CH Life'!C[2],Match!RC[-4])*2"
Range("H5").Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS(LTD!C[4],LTD!C[-2],Match!RC[-6],LTD!C[1],Match!RC[-5])*2"
Range("I5").Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS('Basic AD&D'!C[3],'Basic AD&D'!C[-3],Match!RC[-7],'Basic AD&D'!C,Match!RC[-6])*2"
Range("J5").Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS(STD!C[2],STD!C[-4],Match!RC[-8],STD!C[-1],Match!RC[-7])*2"
Range("K5").Select
ActiveCell.FormulaR1C1 = "=SUM(RC[-7]:RC[-1])"
Range("D5:K5").Select
Selection.Copy
Range("D5:K25").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("M13").Select
Application.CutCopyMode = False
Range("D25:K25").Select
Selection.Copy
Range("D28:K29").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("D32:K34").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("D37:K56").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("D59:K66").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("D69:K97").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
And here's the computed Excel based on that code:
[TABLE="width: 630"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="class: xl69, width: 64, bgcolor: transparent"]Div
[/TD]
[TD="class: xl70, width: 200, bgcolor: transparent"]Department
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Basic Life
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Voluntary Life
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Voluntary Spouse Life
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Voluntary Child Life
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Long Term Disability
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Basic AD&D
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Short Term Disability
[/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"]Total
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Admin
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]AWG
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Client Services
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]DVS
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]5
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Executive Management
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Finance
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]7
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Finance Payroll
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Frontline
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]HR
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]10
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Non ED IQ
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]11
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]IT
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]12
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Legal
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]13
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Management
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]14
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Marketing
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]15
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Ops Admin
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]16
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]PMO
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]17
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Procurement
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]18
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]QA
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]19
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Rehab
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]20
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Rehab Management
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]21
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACT
[/TD]
[TD="class: xl66, bgcolor: transparent"]Sales & Marketing
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]22
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACTH
[/TD]
[TD="class: xl66, bgcolor: transparent"]Admin
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]23
[/TD]
[TD="class: xl65, bgcolor: transparent"]ACTH
[/TD]
[TD="class: xl66, bgcolor: transparent"]Executive Management
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]24
[/TD]
[TD="class: xl65, bgcolor: transparent"]CHR
[/TD]
[TD="class: xl66, bgcolor: transparent"]Bad Debt
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]25
[/TD]
[TD="class: xl65, bgcolor: transparent"]CHR
[/TD]
[TD="class: xl66, bgcolor: transparent"]Executive 5010
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]26
[/TD]
[TD="class: xl65, bgcolor: transparent"]CHR
[/TD]
[TD="class: xl66, bgcolor: transparent"]Facility 5114
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl71, bgcolor: transparent"]$-
[/TD]
[TD="class: xl72, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[TD="class: xl74, bgcolor: transparent"]$-
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]