Change VBA to insert copied rows not paste them.

[baby_kay_2003]

Hello! I am new to VBA as you will probably be able to tell. I have read a lot on this forum and I am having a great time learning! I have Office 2013 and Windows 8.1(dont knwo if that matters but to much information is better than not enough!)

My problem:

I need to copy rows of data from the master sheet(sheet4) and insert into other sheets depending on the data in column A. The below code does everything correctly except it paste the rows instead of inserting them which overwrites my subtotaling data at the bottom. If it helps I can insert/paste the copied rows into row 8 in all other sheets as they are all the exact same with exception to the master sheet.

OR...would I be better off making my tech sheets section for pasting longer than then i expected the pasted data to be and have a code to delete unused rows so that my sum formulas on my total page would continue to work.

I really hope this is understandable as I am horrible at explaining things. lol

The code I was trying:
Sub Master_to_tech()

'872006
Dim lastrow As Long, lastcol As Long, nextrow As Long
Dim rng As Range

Application.ScreenUpdating = False

nextrow = Sheet2.Cells(Rows.Count, "A").End(xlUp).Row + 1

With Sheet4
lastrow = .Cells(Rows.Count, "F").End(xlUp).Row
lastcol = .Cells(1, Columns.Count).End(xlToLeft).Column
.AutoFilterMode = False
Set rng = .Range("A1", .Cells(lastrow, lastcol))
rng.AutoFilter field:=1, Criteria1:="DVOK872006"
rng.Offset(1, 0).SpecialCells(12).Copy Sheet2.Range("A" & nextrow)
rng.Offset(1, 0).EntireRow.Delete Shift:=xlUp
.AutoFilterMode = False
End With

Application.CutCopyMode = False
Application.ScreenUpdating = True

Set rng = Nothing

'872008
Application.ScreenUpdating = False

nextrow = Sheet3.Cells(Rows.Count, "A").End(xlUp).Row + 1

With Sheet4
lastrow = .Cells(Rows.Count, "F").End(xlUp).Row
lastcol = .Cells(1, Columns.Count).End(xlToLeft).Column
.AutoFilterMode = False
Set rng = .Range("A1", .Cells(lastrow, lastcol))
rng.AutoFilter field:=1, Criteria1:="DVOK872008"
rng.Offset(1, 0).SpecialCells(12).Copy Sheet3.Range("A" & nextrow)
rng.Offset(1, 0).EntireRow.Delete Shift:=xlUp
.AutoFilterMode = False
End With
End Sub

I have attached a very short version of my workbook(as in the end it will have over 40 sheets) and what I need the end result to be. Thanks so much in advance!

Mastersheet:

<colgroup><col style="mso-width-source:userset;mso-width-alt:4039; width:85pt" span="4" width="114"> <col style="mso-width-source:userset;mso-width-alt:4551;width:96pt" width="128"> <col style="mso-width-source:userset;mso-width-alt:4039;width:85pt" width="114"> <col style="mso-width-source:userset;mso-width-alt:56;width:1pt" width="2"> </colgroup><tbody>
[TD="class: xl79, width: 114"]Tech ID[/TD]
[TD="class: xl79, width: 114"]Activity ID[/TD]
[TD="class: xl79, width: 114"]Order Sub Type[/TD]
[TD="class: xl79, width: 114"]Account Number[/TD]
[TD="class: xl79, width: 128"]Activity Date[/TD]
[TD="class: xl80, width: 114"]Payment [/TD]
[TD="class: xl81, width: 2"][/TD]

[TD="class: xl73"]DVOK872006[/TD]
[TD="class: xl73"]1-1Q3QTLW6[/TD]
[TD="class: xl73"]Former Install[/TD]
[TD="class: xl82"]*3424*5[/TD]
[TD="class: xl75, align: right"]9/12/2014 4:09 PM[/TD]
[TD="class: xl76"] $ 100.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872006[/TD]
[TD="class: xl73"]1-1Q4TJ35V[/TD]
[TD="class: xl73"]New Install[/TD]
[TD="class: xl82"]**9*0*9*[/TD]
[TD="class: xl75, align: right"]9/13/2014 2:10 PM[/TD]
[TD="class: xl76"] $ 95.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872006[/TD]
[TD="class: xl73"]1-1Q7XVETC[/TD]
[TD="class: xl73"]Service[/TD]
[TD="class: xl82"]3*35**04[/TD]
[TD="class: xl75, align: right"]9/13/2014 1:05 PM[/TD]
[TD="class: xl76"] $ 25.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872006[/TD]
[TD="class: xl73"]1-1QBRTTBL[/TD]
[TD="class: xl73"]Service[/TD]
[TD="class: xl82"]34*0334[/TD]
[TD="class: xl75, align: right"]9/13/2014 1:04 PM[/TD]
[TD="class: xl76"] $ 25.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872006[/TD]
[TD="class: xl73"]1-1QBU5YNY[/TD]
[TD="class: xl73"]New Install[/TD]
[TD="class: xl82"]*5*0004[/TD]
[TD="class: xl75, align: right"]9/12/2014 1:37 PM[/TD]
[TD="class: xl76"] $ 125.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872006[/TD]
[TD="class: xl73"]1-1QCD2GW3[/TD]
[TD="class: xl73"]Service[/TD]
[TD="class: xl82"]**53*45*[/TD]
[TD="class: xl75, align: right"]9/13/2014 1:04 PM[/TD]
[TD="class: xl76"] $ 25.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872006[/TD]
[TD="class: xl73"]1-1QD3WQMQ[/TD]
[TD="class: xl73"]Upgrade[/TD]
[TD="class: xl82"]*2400324[/TD]
[TD="class: xl75, align: right"]9/12/2014 1:37 PM[/TD]
[TD="class: xl76"] $ 35.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872008[/TD]
[TD="class: xl73"]1-1Q6O4R56[/TD]
[TD="class: xl73"]Former Install[/TD]
[TD="class: xl82"]4*24**39[/TD]
[TD="class: xl75, align: right"]9/12/2014 6:17 PM[/TD]
[TD="class: xl77"] $ 110.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872008[/TD]
[TD="class: xl73"]1-1Q9W91AP[/TD]
[TD="class: xl73"]Former Install[/TD]
[TD="class: xl82"]34**299*[/TD]
[TD="class: xl75, align: right"]9/15/2014 4:23 PM[/TD]
[TD="class: xl77"] $ 110.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872008[/TD]
[TD="class: xl73"]1-1QA5NNOQ[/TD]
[TD="class: xl73"]Upgrade[/TD]
[TD="class: xl82"]4009****[/TD]
[TD="class: xl75, align: right"]9/12/2014 3:45 PM[/TD]
[TD="class: xl77"] $ 45.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872008[/TD]
[TD="class: xl73"]1-1QCP6VYW[/TD]
[TD="class: xl73"]New Install[/TD]
[TD="class: xl82"]30*3*03[/TD]
[TD="class: xl75, align: right"]9/12/2014 10:05 AM[/TD]
[TD="class: xl77"] $ 125.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872008[/TD]
[TD="class: xl73"]1-1QFETJRZ[/TD]
[TD="class: xl73"]New Install[/TD]
[TD="class: xl82"]2*05*4*0[/TD]
[TD="class: xl75, align: right"]9/15/2014 9:49 AM[/TD]
[TD="class: xl77"] $ 125.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872008[/TD]
[TD="class: xl73"]1-1QGEFBFQ[/TD]
[TD="class: xl73"]New Install[/TD]
[TD="class: xl82"]**4*33*[/TD]
[TD="class: xl75, align: right"]9/15/2014 1:05 PM[/TD]
[TD="class: xl77"] $ 125.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872008[/TD]
[TD="class: xl73"]1-1QBXI29D[/TD]
[TD="class: xl73"]Upgrade[/TD]
[TD="class: xl82"]***4923*[/TD]
[TD="class: xl75, align: right"]9/14/2014 2:11 PM[/TD]
[TD="class: xl77"] $ 30.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872008[/TD]
[TD="class: xl73"]1-1QCF929U[/TD]
[TD="class: xl73"]Upgrade[/TD]
[TD="class: xl82"]*40*4*00[/TD]
[TD="class: xl75, align: right"]9/14/2014 2:25 PM[/TD]
[TD="class: xl77"] $ 20.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1PUH1L1R[/TD]
[TD="class: xl73"]Former Install[/TD]
[TD="class: xl82"]**9*0*9*[/TD]
[TD="class: xl75, align: right"]9/12/2014 3:41 PM[/TD]
[TD="class: xl77"] $ 110.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1Q5SO951[/TD]
[TD="class: xl73"]Upgrade[/TD]
[TD="class: xl82"]3*35**04[/TD]
[TD="class: xl75, align: right"]9/12/2014 9:00 AM[/TD]
[TD="class: xl77"] $ 50.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QBK2CAF[/TD]
[TD="class: xl73"]Former Install[/TD]
[TD="class: xl82"]34*0334[/TD]
[TD="class: xl75, align: right"]9/12/2014 12:33 PM[/TD]
[TD="class: xl77"] $ 95.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QBR6H11[/TD]
[TD="class: xl73"]Upgrade[/TD]
[TD="class: xl82"]*5*0004[/TD]
[TD="class: xl75, align: right"]9/12/2014 9:58 AM[/TD]
[TD="class: xl77"] $ 30.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QCMC58L[/TD]
[TD="class: xl73"]Service[/TD]
[TD="class: xl82"]**53*45*[/TD]
[TD="class: xl75, align: right"]9/15/2014 4:41 PM[/TD]
[TD="class: xl77"] $ 25.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QD6UM5L[/TD]
[TD="class: xl73"]New Install[/TD]
[TD="class: xl82"]**9*0*9*[/TD]
[TD="class: xl75, align: right"]9/16/2014 12:28 PM[/TD]
[TD="class: xl77"] $ 95.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QDHVE6M[/TD]
[TD="class: xl73"]Upgrade[/TD]
[TD="class: xl82"]3*35**04[/TD]
[TD="class: xl75, align: right"]9/16/2014 9:56 AM[/TD]
[TD="class: xl77"] $ 35.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QFCO8Q8[/TD]
[TD="class: xl73"]New Install[/TD]
[TD="class: xl82"]34*0334[/TD]
[TD="class: xl75, align: right"]9/15/2014 9:52 AM[/TD]
[TD="class: xl77"] $ 95.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QFSKEAU[/TD]
[TD="class: xl73"]New Install[/TD]
[TD="class: xl82"]*5*0004[/TD]
[TD="class: xl75, align: right"]9/15/2014 2:44 PM[/TD]
[TD="class: xl77"] $ 125.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QHYHZFO[/TD]
[TD="class: xl73"]Upgrade[/TD]
[TD="class: xl82"]**53*45*[/TD]
[TD="class: xl75, align: right"]9/15/2014 4:26 PM[/TD]
[TD="class: xl77"] $ 35.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QI0TBRP[/TD]
[TD="class: xl73"]Service[/TD]
[TD="class: xl82"]335***3[/TD]
[TD="class: xl75, align: right"]9/15/2014 8:06 AM[/TD]
[TD="class: xl77"] $ 25.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QK2V6LD[/TD]
[TD="class: xl73"]Service[/TD]
[TD="class: xl82"]*5*****9[/TD]
[TD="class: xl75, align: right"]9/18/2014 5:49 AM[/TD]
[TD="class: xl77"] $ 25.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QLA15YP[/TD]
[TD="class: xl73"]New Install[/TD]
[TD="class: xl82"]*5***3*9[/TD]
[TD="class: xl75, align: right"]9/18/2014 9:56 AM[/TD]
[TD="class: xl77"] $ 110.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QLHGMFG[/TD]
[TD="class: xl73"]Service[/TD]
[TD="class: xl82"]**43**0*[/TD]
[TD="class: xl75, align: right"]9/18/2014 4:16 PM[/TD]
[TD="class: xl77"] $ 25.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1Q829FOT[/TD]
[TD="class: xl73"]New Install[/TD]
[TD="class: xl82"]*52*542[/TD]
[TD="class: xl75, align: right"]9/16/2014 4:12 PM[/TD]
[TD="class: xl77"] $ 95.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1Q9Q3LLN[/TD]
[TD="class: xl73"]Upgrade[/TD]
[TD="class: xl82"]344*09*2[/TD]
[TD="class: xl75, align: right"]9/13/2014 11:16 AM[/TD]
[TD="class: xl77"] $ 30.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QAQK7P2[/TD]
[TD="class: xl73"]New Install[/TD]
[TD="class: xl82"]**9*0*9*[/TD]
[TD="class: xl75, align: right"]9/13/2014 12:49 PM[/TD]
[TD="class: xl77"] $ 80.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QIKE00R[/TD]
[TD="class: xl73"]Upgrade[/TD]
[TD="class: xl82"]3*35**04[/TD]
[TD="class: xl75, align: right"]9/17/2014 2:25 PM[/TD]
[TD="class: xl78"] $ 35.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QIRHG7W[/TD]
[TD="class: xl73"]Service[/TD]
[TD="class: xl82"]34*0334[/TD]
[TD="class: xl75, align: right"]9/16/2014 1:20 PM[/TD]
[TD="class: xl78"] $ 25.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014[/TD]
[TD="class: xl73"]1-1QIVCSXU[/TD]
[TD="class: xl73"]Former Install[/TD]
[TD="class: xl82"]*5*0004[/TD]
[TD="class: xl75, align: right"]9/17/2014 10:45 AM[/TD]
[TD="class: xl78"] $ 110.00 [/TD]
[TD="class: xl74"][/TD]

[TD="class: xl73"]DVOK872014
[/TD]
[TD="class: xl73"]1-1QJVZ6T0[/TD]
[TD="class: xl73"]Upgrade[/TD]
[TD="class: xl82"]**53*45*[/TD]
[TD="class: xl75, align: right"]9/17/2014 2:01 PM[/TD]
[TD="class: xl78"] $ 35.00
[/TD]
[TD="class: xl74"][/TD]

</tbody>

Tech Sheet:

<colgroup><col style="mso-width-source:userset;mso-width-alt:3925; width:83pt" span="4" width="110"> <col style="mso-width-source:userset;mso-width-alt:4551;width:96pt" width="128"> <col style="mso-width-source:userset;mso-width-alt:3925;width:83pt" width="110"> <col style="mso-width-source:userset;mso-width-alt:56;width:1pt" width="2"> </colgroup><tbody>
[TD="class: xl98, width: 110"][/TD]
[TD="class: xl98, width: 110"] [/TD]
[TD="class: xl99, width: 110"] [/TD]
[TD="class: xl97, width: 110"][/TD]
[TD="class: xl97, width: 128"][/TD]
[TD="class: xl97, width: 110"][/TD]
[TD="class: xl97, width: 2"][/TD]

[TD="class: xl98"]Pay Period Ending[/TD]
[TD="class: xl100"]9/25/2014[/TD]
[TD="class: xl97"][/TD]
[TD="class: xl101"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl94"][/TD]
[TD="class: xl94"][/TD]

[TD="class: xl94"][/TD]
[TD="class: xl94"][/TD]
[TD="class: xl94"][/TD]
[TD="class: xl94"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl94"][/TD]
[TD="class: xl97"][/TD]

[TD="class: xl93"]Tech Name [/TD]
[TD="class: xl94"][/TD]
[TD="class: xl94"][/TD]
[TD="class: xl93"]Tech Number [/TD]
[TD="class: xl95"] DVOK872006 [/TD]
[TD="class: xl93"][/TD]
[TD="class: xl97"][/TD]

[TD="class: xl93"][/TD]
[TD="class: xl93"][/TD]
[TD="class: xl94"][/TD]
[TD="class: xl93"][/TD]
[TD="class: xl96"][/TD]
[TD="class: xl94"][/TD]
[TD="class: xl97"][/TD]

[TD="class: xl90"]Tech ID[/TD]
[TD="class: xl90"]Activity ID[/TD]
[TD="class: xl90"]Order Sub Type[/TD]
[TD="class: xl90"]Account Number[/TD]
[TD="class: xl90"]Activity Date[/TD]
[TD="class: xl91"]Payment [/TD]
[TD="class: xl92"][/TD]

[TD="class: xl86"] [/TD]
[TD="class: xl86"] [/TD]
[TD="class: xl86"] [/TD]
[TD="class: xl87"] [/TD]
[TD="class: xl88"] [/TD]
[TD="class: xl89"] [/TD]
[TD="class: xl85"][/TD]

[TD="class: xl81"][/TD]

[TD="class: xl79"]Sub Total [/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl75"]$0.00[/TD]

[TD="class: xl81"][/TD]

[TD="class: xl80"]Company Fee[/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"]$0.00[/TD]

[TD="class: xl81"][/TD]

[TD="class: xl80, colspan: 2"]Invoice Deduction (Child Support)[/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"]$0.00[/TD]
[TD="colspan: 3"]`[/TD]

[TD="class: xl81"][/TD]

[TD="class: xl80, colspan: 2"]Invoice Deduction (Loan from Eric)[/TD]
[TD="class: xl81"][/TD]
[TD="class: xl82"]$0.00[/TD]

[TD="class: xl81"][/TD]

[TD="class: xl79"]Sub Total [/TD]
[TD="class: xl81"][/TD]
[TD="class: xl81"][/TD]
[TD="class: xl75"]$0.00[/TD]

[TD="class: xl81"][/TD]

[TD="class: xl76"]Insurance [/TD]
[TD="class: xl76"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl83"] $ - [/TD]

[TD="class: xl81"][/TD]

[TD="class: xl78"]Total
[/TD]
[TD="class: xl78"][/TD]
[TD="class: xl78"][/TD]
[TD="class: xl84, align: right"]$0.00
[/TD]

</tbody>

After Code:
blank on master sheet




After code tech sheet:

<colgroup><col style="mso-width-source:userset;mso-width-alt:3925; width:83pt" span="4" width="110"> <col style="mso-width-source:userset;mso-width-alt:4551;width:96pt" width="128"> <col style="mso-width-source:userset;mso-width-alt:3925;width:83pt" width="110"> <col style="mso-width-source:userset;mso-width-alt:56;width:1pt" width="2"> </colgroup><tbody>
[TD="class: xl95, width: 110"] [/TD]
[TD="class: xl95, width: 110"] [/TD]
[TD="class: xl96, width: 110"] [/TD]
[TD="class: xl94, width: 110"][/TD]
[TD="class: xl94, width: 128"][/TD]
[TD="class: xl94, width: 110"][/TD]
[TD="class: xl94, width: 2"][/TD]

[TD="class: xl95"]Pay Period Ending[/TD]
[TD="class: xl97"]9/25/2014[/TD]
[TD="class: xl94"][/TD]
[TD="class: xl98"][/TD]
[TD="class: xl92"][/TD]
[TD="class: xl91"][/TD]
[TD="class: xl91"][/TD]

[TD="class: xl91"][/TD]
[TD="class: xl91"][/TD]
[TD="class: xl91"][/TD]
[TD="class: xl91"][/TD]
[TD="class: xl92"][/TD]
[TD="class: xl91"][/TD]
[TD="class: xl94"][/TD]

[TD="class: xl90"]Tech Name [/TD]
[TD="class: xl91"][/TD]
[TD="class: xl91"][/TD]
[TD="class: xl90"]Tech Number [/TD]
[TD="class: xl92"] DVOK872006 [/TD]
[TD="class: xl90"][/TD]
[TD="class: xl94"][/TD]

[TD="class: xl90"][/TD]
[TD="class: xl90"][/TD]
[TD="class: xl91"][/TD]
[TD="class: xl90"][/TD]
[TD="class: xl93"][/TD]
[TD="class: xl91"][/TD]
[TD="class: xl94"][/TD]

[TD="class: xl87"]Tech ID[/TD]
[TD="class: xl87"]Activity ID[/TD]
[TD="class: xl87"]Order Sub Type[/TD]
[TD="class: xl87"]Account Number[/TD]
[TD="class: xl87"]Activity Date[/TD]
[TD="class: xl88"]Payment [/TD]
[TD="class: xl89"][/TD]

[TD="class: xl83"]DVOK872006[/TD]
[TD="class: xl83"]1-1Q3QTLW6[/TD]
[TD="class: xl83"]Former Install[/TD]
[TD="class: xl99"]*3424*5[/TD]
[TD="class: xl85, align: right"]9/12/2014 4:09 PM[/TD]
[TD="class: xl86"] $ 100.00 [/TD]
[TD="class: xl84"][/TD]

[TD="class: xl83"]DVOK872006[/TD]
[TD="class: xl83"]1-1Q4TJ35V[/TD]
[TD="class: xl83"]New Install[/TD]
[TD="class: xl99"]**9*0*9*[/TD]
[TD="class: xl85, align: right"]9/13/2014 2:10 PM[/TD]
[TD="class: xl86"] $ 95.00 [/TD]
[TD="class: xl84"][/TD]

[TD="class: xl83"]DVOK872006[/TD]
[TD="class: xl83"]1-1Q7XVETC[/TD]
[TD="class: xl83"]Service[/TD]
[TD="class: xl99"]3*35**04[/TD]
[TD="class: xl85, align: right"]9/13/2014 1:05 PM[/TD]
[TD="class: xl86"] $ 25.00 [/TD]
[TD="class: xl84"][/TD]

[TD="class: xl83"]DVOK872006[/TD]
[TD="class: xl83"]1-1QBRTTBL[/TD]
[TD="class: xl83"]Service[/TD]
[TD="class: xl99"]34*0334[/TD]
[TD="class: xl85, align: right"]9/13/2014 1:04 PM[/TD]
[TD="class: xl86"] $ 25.00 [/TD]
[TD="class: xl84"][/TD]

[TD="class: xl83"]DVOK872006[/TD]
[TD="class: xl83"]1-1QBU5YNY[/TD]
[TD="class: xl83"]New Install[/TD]
[TD="class: xl99"]*5*0004[/TD]
[TD="class: xl85, align: right"]9/12/2014 1:37 PM[/TD]
[TD="class: xl86"] $ 125.00 [/TD]
[TD="class: xl84"][/TD]

[TD="class: xl83"]DVOK872006[/TD]
[TD="class: xl83"]1-1QCD2GW3[/TD]
[TD="class: xl83"]Service[/TD]
[TD="class: xl99"]**53*45*[/TD]
[TD="class: xl85, align: right"]9/13/2014 1:04 PM[/TD]
[TD="class: xl86"] $ 25.00 [/TD]
[TD="class: xl84"][/TD]

[TD="class: xl83"]DVOK872006[/TD]
[TD="class: xl83"]1-1QD3WQMQ[/TD]
[TD="class: xl83"]Upgrade[/TD]
[TD="class: xl99"]*2400324[/TD]
[TD="class: xl85, align: right"]9/12/2014 1:37 PM[/TD]
[TD="class: xl86"] $ 35.00 [/TD]
[TD="class: xl84"][/TD]

[TD="class: xl79"][/TD]

[TD="class: xl77"]Sub Total [/TD]
[TD="class: xl79"][/TD]
[TD="class: xl79"][/TD]
[TD="class: xl73"]$430.00[/TD]

[TD="class: xl79"][/TD]

[TD="class: xl78"]Company Fee[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"]$0.00[/TD]

[TD="class: xl79"][/TD]

[TD="class: xl78, colspan: 2"]Invoice Deduction (Child Support)[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"]$0.00[/TD]
[TD="colspan: 3"]`[/TD]

[TD="class: xl79"][/TD]

[TD="class: xl78, colspan: 2"]Invoice Deduction (Loan from Eric)[/TD]
[TD="class: xl79"][/TD]
[TD="class: xl80"]$0.00[/TD]

[TD="class: xl79"][/TD]

[TD="class: xl77"]Sub Total [/TD]
[TD="class: xl79"][/TD]
[TD="class: xl79"][/TD]
[TD="class: xl73"]$430.00[/TD]

[TD="class: xl79"][/TD]

[TD="class: xl74"]Insurance [/TD]
[TD="class: xl74"][/TD]
[TD="class: xl75"][/TD]
[TD="class: xl81"] $ (21.07)[/TD]

[TD="class: xl79"][/TD]

[TD="class: xl76"]Total [/TD]
[TD="class: xl76"][/TD]
[TD="class: xl76"][/TD]
[TD="class: xl82, align: right"]$408.93[/TD]

</tbody>

Total page doesnt work anymore after manual insert of rows...only on paste (if I have enough rows...but then I have to manually delete them)

<colgroup><col style="mso-width-source:userset;mso-width-alt:4551;width:96pt" width="128"> <col style="mso-width-source:userset;mso-width-alt:3527;width:74pt" width="99"> <col style="mso-width-source:userset;mso-width-alt:4295;width:91pt" width="121"> <col style="mso-width-source:userset;mso-width-alt:4295; width:91pt" span="2" width="121"> <col style="mso-width-source:userset;mso-width-alt:227;width:5pt" width="6"> </colgroup><tbody>
[TD="class: xl78, width: 128"] [/TD]
[TD="class: xl78, width: 99"] [/TD]
[TD="class: xl79, width: 121"] [/TD]
[TD="class: xl80, width: 121"][/TD]
[TD="class: xl80, width: 121"][/TD]
[TD="class: xl80, width: 6"][/TD]

[TD="class: xl78"]Pay Period Ending[/TD]
[TD="class: xl81"]9/25/2014[/TD]
[TD="class: xl80"][/TD]
[TD="class: xl82"][/TD]
[TD="class: xl83"][/TD]
[TD="class: xl84"][/TD]

[TD="class: xl85"][/TD]
[TD="class: xl86"][/TD]
[TD="class: xl87"][/TD]
[TD="class: xl88"][/TD]
[TD="class: xl89"][/TD]
[TD="class: xl75"][/TD]

[TD="class: xl76"]Tech Name[/TD]
[TD="class: xl76"]Tech Number
[/TD]
[TD="class: xl76"]After Insurance [/TD]
[TD="class: xl76"]Before Insurance [/TD]
[TD="class: xl76"]Sub total[/TD]
[TD="class: xl77"][/TD]

[TD="class: xl90"]Brandon Stancell[/TD]
[TD="class: xl92"] DVOK872006 [/TD]
[TD="class: xl91"] $ 408.93 [/TD]
[TD="class: xl91"] $ 430.00 [/TD]
[TD="class: xl91"] $ 408.93 [/TD]
[TD="class: xl93"][/TD]

[TD="class: xl90"]Chris Jetton [/TD]
[TD="class: xl92"] DVOK872008 [/TD]
[TD="class: xl91"] $ 656.19 [/TD]
[TD="class: xl91"] $ 690.00 [/TD]
[TD="class: xl91"] $ 690.00 [/TD]
[TD="class: xl87"][/TD]

[TD="class: xl90"]Oscar Lopez[/TD]
[TD="class: xl92"] DVOK872014 [/TD]
[TD="class: xl91"] $ 1,226.79 [/TD]
[TD="class: xl91"] $ 1,290.00 [/TD]
[TD="class: xl91"] $ 1,290.00 [/TD]
[TD="class: xl87"][/TD]

[TD="class: xl95"][/TD]
[TD="class: xl95"][/TD]
[TD="class: xl96"][/TD]
[TD="class: xl96"][/TD]
[TD="class: xl96"][/TD]
[TD="class: xl93"][/TD]

[TD="class: xl97"]Total[/TD]
[TD="class: xl97"] [/TD]
[TD="class: xl98"] $ 2,291.91 [/TD]
[TD="class: xl98"] $ 2,410.00 [/TD]
[TD="class: xl98"] $ 2,388.93 [/TD]
[TD="class: xl94"] [/TD]

[TD="class: xl87"][/TD]
[TD="class: xl77"][/TD]
[TD="class: xl99"][/TD]
[TD="class: xl87"][/TD]
[TD="class: xl87"][/TD]
[TD="class: xl93"][/TD]

[TD="class: xl93"][/TD]
[TD="class: xl100"][/TD]
[TD="class: xl93"][/TD]
[TD="class: xl93"][/TD]
[TD="class: xl93"][/TD]
[TD="class: xl93"][/TD]

</tbody>

 

[baby_kay_2003]

Trying to edit to put in code tags but do not see a way to edit..