I have a workbook that has several worksheets and a lot of data. I have the first worksheet( named Totals)set up to copy and paste data from all the other worksheets one at a time when you click on a button. I had to add some addition formulas to my worksheet to get them to tatol correctly.
Now whenI copy them to the totals page. I get a div/o! error and only my formulas are being copied over. I know I need to paste special but I can't seem to work out a macro that will do that. I was using this on one of the worksheets set up on a button, but its not working corectly now.
Sub Apollo()
Worksheets("Apollo"). _
Range("A4:AK427").Copy _
Destination:= _
Worksheets("Totals"). _
Range("A4:AK427")
End Sub
Does anyone have any suggestions? I'm Lost.
This on another button
Sub ApolloWKLY()
Sheets("Totals").UsedRange.Offset(3).Clear
Sheets("Apollo WKLY").Range("4:4,5:5,13:13,21:21,29:29,37:37,45:45,53:53,61:61,69:69,77:77,85:85,93:93,101:101,109:109,117:117,125:125,133:133,141:141,149:149,157:157,165:165,173:173,181:181,189:189,197:197,205:205,213:213,221:221,229:229,237:237,245:245,253:253,261:261").Copy Sheets("Totals").Range("A4")
Sheets("Apollo WKLY").Range("269:269,277:277,285:285,293:293,301:301,309:309,317:317,325:325,333:333,341:341,349:349,357:357,365:365,373:373,381:381,389:389,397:397,405:405,413:413,421:421,426:426,427:427").Copy Sheets("Totals").Range("A38")
End Sub
And this on another button
Sub ApolloMthly()
Sheets("Totals").UsedRange.Offset(3).Clear
Sheets("Apollo Mthly").Range("4:4,5:5,9:9,41:41,70:70,102:102,133:133,165:165,196:196,228:228,260:260,291:291,323:323,354:354,386:386").Copy Sheets("Totals").Range("A4")
Sheets("Apollo Mthly").Range("387:387,388:388,389:389,391:391,392:392").Copy Sheets("Totals").Range("A19")
End Sub
I also tried this but I get a error
Sub Macro4()
'
' Macro4 Macro
'
'
Sheets("Sabre").Select
Range("Y23").Select
Range("A4:AK427").Select
Selection.Copy
Sheets("Totals").Select
Range("A4:AK427").SelectSelection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
My boss uses this for a huddle sheet
<TABLE style="WIDTH: 324pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=435 border=0><COLGROUP><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" span=5 width=47><COL style="WIDTH: 9pt; mso-width-source: userset; mso-width-alt: 438" width=12><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" span=4 width=47><TBODY><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl83 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 175pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=235 colSpan=5 height=17>AHT</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 9pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white" width=12> </TD><TD class=xl86 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=188 colSpan=4>SLA %</TD></TR><TR style="HEIGHT: 18pt; mso-height-source: userset" height=24><TD class=xl78 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: silver" width=47 height=24>AHT</TD><TD class=xl78 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>India</TD><TD class=xl78 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>Miami</TD><TD class=xl78 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>Dickenson</TD><TD class=xl78 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>Dearborn</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 9pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white" width=12></TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>SLA% 1hr</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>SLA% 2hr</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>SLA% 4hr</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>SLA% Daily</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver 0.5pt solid; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: white" height=14>#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl69 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: white" height=14>#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl69 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: white" height=14>#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl69 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: white" height=14>#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl69 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: white" height=14>#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl69 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: white" height=14>#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl69 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: white" height=14>#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl69 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl80 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: #bfbfbf" height=14>#DIV/0!</TD><TD class=xl80 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD><TD class=xl80 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD><TD class=xl80 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD><TD class=xl80 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD><TD class=xl76 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl81 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD><TD class=xl81 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD><TD class=xl81 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD><TD class=xl82 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD></TR></TBODY></TABLE>
Now whenI copy them to the totals page. I get a div/o! error and only my formulas are being copied over. I know I need to paste special but I can't seem to work out a macro that will do that. I was using this on one of the worksheets set up on a button, but its not working corectly now.
Sub Apollo()
Worksheets("Apollo"). _
Range("A4:AK427").Copy _
Destination:= _
Worksheets("Totals"). _
Range("A4:AK427")
End Sub
Does anyone have any suggestions? I'm Lost.
This on another button
Sub ApolloWKLY()
Sheets("Totals").UsedRange.Offset(3).Clear
Sheets("Apollo WKLY").Range("4:4,5:5,13:13,21:21,29:29,37:37,45:45,53:53,61:61,69:69,77:77,85:85,93:93,101:101,109:109,117:117,125:125,133:133,141:141,149:149,157:157,165:165,173:173,181:181,189:189,197:197,205:205,213:213,221:221,229:229,237:237,245:245,253:253,261:261").Copy Sheets("Totals").Range("A4")
Sheets("Apollo WKLY").Range("269:269,277:277,285:285,293:293,301:301,309:309,317:317,325:325,333:333,341:341,349:349,357:357,365:365,373:373,381:381,389:389,397:397,405:405,413:413,421:421,426:426,427:427").Copy Sheets("Totals").Range("A38")
End Sub
And this on another button
Sub ApolloMthly()
Sheets("Totals").UsedRange.Offset(3).Clear
Sheets("Apollo Mthly").Range("4:4,5:5,9:9,41:41,70:70,102:102,133:133,165:165,196:196,228:228,260:260,291:291,323:323,354:354,386:386").Copy Sheets("Totals").Range("A4")
Sheets("Apollo Mthly").Range("387:387,388:388,389:389,391:391,392:392").Copy Sheets("Totals").Range("A19")
End Sub
I also tried this but I get a error
Sub Macro4()
'
' Macro4 Macro
'
'
Sheets("Sabre").Select
Range("Y23").Select
Range("A4:AK427").Select
Selection.Copy
Sheets("Totals").Select
Range("A4:AK427").SelectSelection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
My boss uses this for a huddle sheet
<TABLE style="WIDTH: 324pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=435 border=0><COLGROUP><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" span=5 width=47><COL style="WIDTH: 9pt; mso-width-source: userset; mso-width-alt: 438" width=12><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" span=4 width=47><TBODY><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl83 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 175pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=235 colSpan=5 height=17>AHT</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 9pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white" width=12> </TD><TD class=xl86 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=188 colSpan=4>SLA %</TD></TR><TR style="HEIGHT: 18pt; mso-height-source: userset" height=24><TD class=xl78 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: silver" width=47 height=24>AHT</TD><TD class=xl78 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>India</TD><TD class=xl78 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>Miami</TD><TD class=xl78 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>Dickenson</TD><TD class=xl78 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>Dearborn</TD><TD class=xl73 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 9pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white" width=12></TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>SLA% 1hr</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>SLA% 2hr</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>SLA% 4hr</TD><TD class=xl75 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver" width=47>SLA% Daily</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver 0.5pt solid; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: white" height=14>#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver 0.5pt solid; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl69 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: white" height=14>#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl69 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: white" height=14>#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl69 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: white" height=14>#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl69 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: white" height=14>#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl69 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: white" height=14>#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl69 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: white" height=14>#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl79 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl67 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl68 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD><TD class=xl69 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: white">#DIV/0!</TD></TR><TR style="HEIGHT: 11.1pt; mso-height-source: userset; mso-outline-level: 1; mso-outline-parent: collapsed" height=14><TD class=xl80 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; HEIGHT: 11.1pt; BACKGROUND-COLOR: #bfbfbf" height=14>#DIV/0!</TD><TD class=xl80 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD><TD class=xl80 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD><TD class=xl80 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD><TD class=xl80 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: silver; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD><TD class=xl76 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: white"> </TD><TD class=xl81 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver 0.5pt solid; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD><TD class=xl81 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD><TD class=xl81 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD><TD class=xl82 style="BORDER-RIGHT: silver 0.5pt solid; BORDER-TOP: #d4d0c8; BORDER-LEFT: silver; BORDER-BOTTOM: silver 0.5pt solid; BACKGROUND-COLOR: #bfbfbf">#DIV/0!</TD></TR></TBODY></TABLE>