Copy and Paste

Thollis

New Member
Joined
Dec 30, 2008
Messages
35
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>
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
I adjusted your code to PasteSpecial Values:
Also removed all "Selections" that are not needed.
Code:
Sub Apollo()
    Worksheets("Apollo").Range("A4:AK427").Copy
    Worksheets("Totals").Range("A4").PasteSpecial Paste:=xlPasteValues
    'This line turns off Copy Marquee on copied range
    Application.CutCopyMode = False 
End Sub
Code:
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:14 1,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:26 1").Copy
Sheets("Totals").Range("A4").PasteSpecial Paste:=xlPasteValues

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").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False

End Sub
Code:
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").PasteSpecial Paste:=xlPasteValues

Sheets("Apollo Mthly").Range("387:387,388:388,389:389,391:391,392:392").Copy
Sheets("Totals").Range("A19").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False

End Sub
Code:
Sub Macro4()
    Sheets("Sabre").Range("A4:K27").Copy
    Sheets("Totals").Range("A4").PasteSpecial Paste:=xlPasteValues
    Application.CutCopyMode = False
End Sub
 
Upvote 0

Forum statistics

Threads
1,213,514
Messages
6,114,078
Members
448,547
Latest member
arndtea

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