Copy data from one workbook to another workbook

C

clarkster

New Member
Joined
Jul 29, 2010
Messages
10
I have a macro here that copies cells c4:ah11 from an external workbook on a network share to this workbook to cells c54:AH61. I need the data to overwrite the data already there each day. I need it to compare the data and ensure it's valid. I want to do this by date so an example would be if the date is 1-apr like below and this is August it will not copy the data but if it is this month or 1 day after this month it will copy the data over.

Sub pull_AP_data()
Dim wbCodeBook As Workbook
Dim rCell As Range
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False
On Error Resume Next
If Sheets("temp") Is Nothing Then
ActiveSheet.Name = ("temp")
Else
End If
Set wbCodeBook = ThisWorkbook
Range("C55:AF55").Select
Selection.NumberFormat = "hh:mm:ss"
Range("C58:AF61").Select
Selection.NumberFormat = "hh:mm:ss"
With Application.FileSearch
.NewSearch
.LookIn = "z:\network share path"
.FileType = msoFileTypeExcelWorkbooks
If .Execute > 0 Then
For lCount = 1 To .FoundFiles.Count
Set wbResults = Workbooks.Open(Filename:=.FoundFiles(lCount), UpdateLinks:=0)
Set rCell = wbCodeBook.Sheets(1).Range("A65536").End(xlUp).Offset(0, 0)
rCell.Offset(53, 2).FormulaR1C1 = wbResults.Sheets(1).Range("c4")
rCell.Offset(53, 3).FormulaR1C1 = wbResults.Sheets(1).Range("d4")
rCell.Offset(53, 4).FormulaR1C1 = wbResults.Sheets(1).Range("e4")
rCell.Offset(53, 5).FormulaR1C1 = wbResults.Sheets(1).Range("f4")
rCell.Offset(53, 6).FormulaR1C1 = wbResults.Sheets(1).Range("g4")
rCell.Offset(53, 7).FormulaR1C1 = wbResults.Sheets(1).Range("h4")
rCell.Offset(53, 8).FormulaR1C1 = wbResults.Sheets(1).Range("i4")
rCell.Offset(53, 9).FormulaR1C1 = wbResults.Sheets(1).Range("j4")
rCell.Offset(53, 10).FormulaR1C1 = wbResults.Sheets(1).Range("k4")
rCell.Offset(53, 11).FormulaR1C1 = wbResults.Sheets(1).Range("l4")
rCell.Offset(53, 12).FormulaR1C1 = wbResults.Sheets(1).Range("m4")
rCell.Offset(53, 13).FormulaR1C1 = wbResults.Sheets(1).Range("n4")
rCell.Offset(53, 14).FormulaR1C1 = wbResults.Sheets(1).Range("o4")
rCell.Offset(53, 15).FormulaR1C1 = wbResults.Sheets(1).Range("p4")
rCell.Offset(53, 16).FormulaR1C1 = wbResults.Sheets(1).Range("q4")
rCell.Offset(53, 17).FormulaR1C1 = wbResults.Sheets(1).Range("r4")
rCell.Offset(53, 18).FormulaR1C1 = wbResults.Sheets(1).Range("s4")
rCell.Offset(53, 19).FormulaR1C1 = wbResults.Sheets(1).Range("t4")
rCell.Offset(53, 20).FormulaR1C1 = wbResults.Sheets(1).Range("u4")
rCell.Offset(53, 21).FormulaR1C1 = wbResults.Sheets(1).Range("v4")
rCell.Offset(53, 22).FormulaR1C1 = wbResults.Sheets(1).Range("w4")
rCell.Offset(53, 23).FormulaR1C1 = wbResults.Sheets(1).Range("x4")
rCell.Offset(53, 24).FormulaR1C1 = wbResults.Sheets(1).Range("y4")
rCell.Offset(53, 25).FormulaR1C1 = wbResults.Sheets(1).Range("z4")
rCell.Offset(53, 26).FormulaR1C1 = wbResults.Sheets(1).Range("AA4")
rCell.Offset(53, 27).FormulaR1C1 = wbResults.Sheets(1).Range("AB4")
rCell.Offset(53, 28).FormulaR1C1 = wbResults.Sheets(1).Range("AC4")
rCell.Offset(53, 29).FormulaR1C1 = wbResults.Sheets(1).Range("AD4")
rCell.Offset(53, 30).FormulaR1C1 = wbResults.Sheets(1).Range("AE4")
rCell.Offset(53, 31).FormulaR1C1 = wbResults.Sheets(1).Range("AF4")
rCell.Offset(53, 32).FormulaR1C1 = wbResults.Sheets(1).Range("AG4")
rCell.Offset(53, 33).FormulaR1C1 = wbResults.Sheets(1).Range("AH4")

rCell.Offset(54, 2).FormulaR1C1 = wbResults.Sheets(1).Range("c5")
rCell.Offset(54, 3).FormulaR1C1 = wbResults.Sheets(1).Range("d5")
rCell.Offset(54, 4).FormulaR1C1 = wbResults.Sheets(1).Range("e5")
rCell.Offset(54, 5).FormulaR1C1 = wbResults.Sheets(1).Range("f5")
rCell.Offset(54, 6).FormulaR1C1 = wbResults.Sheets(1).Range("g5")
rCell.Offset(54, 7).FormulaR1C1 = wbResults.Sheets(1).Range("h5")
rCell.Offset(54, 8).FormulaR1C1 = wbResults.Sheets(1).Range("i5")
rCell.Offset(54, 9).FormulaR1C1 = wbResults.Sheets(1).Range("j5")
rCell.Offset(54, 10).FormulaR1C1 = wbResults.Sheets(1).Range("k5")
rCell.Offset(54, 11).FormulaR1C1 = wbResults.Sheets(1).Range("l5")
rCell.Offset(54, 12).FormulaR1C1 = wbResults.Sheets(1).Range("m5")
rCell.Offset(54, 13).FormulaR1C1 = wbResults.Sheets(1).Range("n5")
rCell.Offset(54, 14).FormulaR1C1 = wbResults.Sheets(1).Range("o5")
rCell.Offset(54, 15).FormulaR1C1 = wbResults.Sheets(1).Range("p5")
rCell.Offset(54, 16).FormulaR1C1 = wbResults.Sheets(1).Range("q5")
rCell.Offset(54, 17).FormulaR1C1 = wbResults.Sheets(1).Range("r5")
rCell.Offset(54, 18).FormulaR1C1 = wbResults.Sheets(1).Range("s5")
rCell.Offset(54, 19).FormulaR1C1 = wbResults.Sheets(1).Range("t5")
rCell.Offset(54, 20).FormulaR1C1 = wbResults.Sheets(1).Range("u5")
rCell.Offset(54, 21).FormulaR1C1 = wbResults.Sheets(1).Range("v5")
rCell.Offset(54, 22).FormulaR1C1 = wbResults.Sheets(1).Range("w5")
rCell.Offset(54, 23).FormulaR1C1 = wbResults.Sheets(1).Range("x5")
rCell.Offset(54, 24).FormulaR1C1 = wbResults.Sheets(1).Range("y5")
rCell.Offset(54, 25).FormulaR1C1 = wbResults.Sheets(1).Range("z5")
rCell.Offset(54, 26).FormulaR1C1 = wbResults.Sheets(1).Range("AA5")
rCell.Offset(54, 27).FormulaR1C1 = wbResults.Sheets(1).Range("AB5")
rCell.Offset(54, 28).FormulaR1C1 = wbResults.Sheets(1).Range("AC5")
rCell.Offset(54, 29).FormulaR1C1 = wbResults.Sheets(1).Range("AD5")
rCell.Offset(54, 30).FormulaR1C1 = wbResults.Sheets(1).Range("AE5")
rCell.Offset(54, 31).FormulaR1C1 = wbResults.Sheets(1).Range("AF5")
rCell.Offset(54, 32).FormulaR1C1 = wbResults.Sheets(1).Range("AG5")
rCell.Offset(54, 33).FormulaR1C1 = wbResults.Sheets(1).Range("AH5")

rCell.Offset(55, 2).FormulaR1C1 = wbResults.Sheets(1).Range("c6")
rCell.Offset(55, 3).FormulaR1C1 = wbResults.Sheets(1).Range("d6")
rCell.Offset(55, 4).FormulaR1C1 = wbResults.Sheets(1).Range("e6")
rCell.Offset(55, 5).FormulaR1C1 = wbResults.Sheets(1).Range("f6")
rCell.Offset(55, 6).FormulaR1C1 = wbResults.Sheets(1).Range("g6")
rCell.Offset(55, 7).FormulaR1C1 = wbResults.Sheets(1).Range("h6")
rCell.Offset(55, 8).FormulaR1C1 = wbResults.Sheets(1).Range("i6")
rCell.Offset(55, 9).FormulaR1C1 = wbResults.Sheets(1).Range("j6")
rCell.Offset(55, 10).FormulaR1C1 = wbResults.Sheets(1).Range("k6")
rCell.Offset(55, 11).FormulaR1C1 = wbResults.Sheets(1).Range("l6")
rCell.Offset(55, 12).FormulaR1C1 = wbResults.Sheets(1).Range("m6")
rCell.Offset(55, 13).FormulaR1C1 = wbResults.Sheets(1).Range("n6")
rCell.Offset(55, 14).FormulaR1C1 = wbResults.Sheets(1).Range("o6")
rCell.Offset(55, 15).FormulaR1C1 = wbResults.Sheets(1).Range("p6")
rCell.Offset(55, 16).FormulaR1C1 = wbResults.Sheets(1).Range("q6")
rCell.Offset(55, 17).FormulaR1C1 = wbResults.Sheets(1).Range("r6")
rCell.Offset(55, 18).FormulaR1C1 = wbResults.Sheets(1).Range("s6")
rCell.Offset(55, 19).FormulaR1C1 = wbResults.Sheets(1).Range("t6")
rCell.Offset(55, 20).FormulaR1C1 = wbResults.Sheets(1).Range("u6")
rCell.Offset(55, 21).FormulaR1C1 = wbResults.Sheets(1).Range("v6")
rCell.Offset(55, 22).FormulaR1C1 = wbResults.Sheets(1).Range("w6")
rCell.Offset(55, 23).FormulaR1C1 = wbResults.Sheets(1).Range("x6")
rCell.Offset(55, 24).FormulaR1C1 = wbResults.Sheets(1).Range("y6")
rCell.Offset(55, 25).FormulaR1C1 = wbResults.Sheets(1).Range("z6")
rCell.Offset(55, 26).FormulaR1C1 = wbResults.Sheets(1).Range("AA6")
rCell.Offset(55, 27).FormulaR1C1 = wbResults.Sheets(1).Range("AB6")
rCell.Offset(55, 28).FormulaR1C1 = wbResults.Sheets(1).Range("AC6")
rCell.Offset(55, 29).FormulaR1C1 = wbResults.Sheets(1).Range("AD6")
rCell.Offset(55, 30).FormulaR1C1 = wbResults.Sheets(1).Range("AE6")
rCell.Offset(55, 31).FormulaR1C1 = wbResults.Sheets(1).Range("AF6")
rCell.Offset(55, 32).FormulaR1C1 = wbResults.Sheets(1).Range("AG6")
rCell.Offset(55, 33).FormulaR1C1 = wbResults.Sheets(1).Range("AH6")

rCell.Offset(56, 2).FormulaR1C1 = wbResults.Sheets(1).Range("c7")
rCell.Offset(56, 3).FormulaR1C1 = wbResults.Sheets(1).Range("d7")
rCell.Offset(56, 4).FormulaR1C1 = wbResults.Sheets(1).Range("e7")
rCell.Offset(56, 5).FormulaR1C1 = wbResults.Sheets(1).Range("f7")
rCell.Offset(56, 6).FormulaR1C1 = wbResults.Sheets(1).Range("g7")
rCell.Offset(56, 7).FormulaR1C1 = wbResults.Sheets(1).Range("h7")
rCell.Offset(56, 8).FormulaR1C1 = wbResults.Sheets(1).Range("i7")
rCell.Offset(56, 9).FormulaR1C1 = wbResults.Sheets(1).Range("j7")
rCell.Offset(56, 10).FormulaR1C1 = wbResults.Sheets(1).Range("k7")
rCell.Offset(56, 11).FormulaR1C1 = wbResults.Sheets(1).Range("l7")
rCell.Offset(56, 12).FormulaR1C1 = wbResults.Sheets(1).Range("m7")
rCell.Offset(56, 13).FormulaR1C1 = wbResults.Sheets(1).Range("n7")
rCell.Offset(56, 14).FormulaR1C1 = wbResults.Sheets(1).Range("o7")
rCell.Offset(56, 15).FormulaR1C1 = wbResults.Sheets(1).Range("p7")
rCell.Offset(56, 16).FormulaR1C1 = wbResults.Sheets(1).Range("q7")
rCell.Offset(56, 17).FormulaR1C1 = wbResults.Sheets(1).Range("r7")
rCell.Offset(56, 18).FormulaR1C1 = wbResults.Sheets(1).Range("s7")
rCell.Offset(56, 19).FormulaR1C1 = wbResults.Sheets(1).Range("t7")
rCell.Offset(56, 20).FormulaR1C1 = wbResults.Sheets(1).Range("u7")
rCell.Offset(56, 21).FormulaR1C1 = wbResults.Sheets(1).Range("v7")
rCell.Offset(56, 22).FormulaR1C1 = wbResults.Sheets(1).Range("w7")
rCell.Offset(56, 23).FormulaR1C1 = wbResults.Sheets(1).Range("x5")
rCell.Offset(56, 24).FormulaR1C1 = wbResults.Sheets(1).Range("y7")
rCell.Offset(56, 25).FormulaR1C1 = wbResults.Sheets(1).Range("z7")
rCell.Offset(56, 26).FormulaR1C1 = wbResults.Sheets(1).Range("AA7")
rCell.Offset(56, 27).FormulaR1C1 = wbResults.Sheets(1).Range("AB7")
rCell.Offset(56, 28).FormulaR1C1 = wbResults.Sheets(1).Range("AC7")
rCell.Offset(56, 29).FormulaR1C1 = wbResults.Sheets(1).Range("AD7")
rCell.Offset(56, 30).FormulaR1C1 = wbResults.Sheets(1).Range("AE7")
rCell.Offset(56, 31).FormulaR1C1 = wbResults.Sheets(1).Range("AF7")
rCell.Offset(56, 32).FormulaR1C1 = wbResults.Sheets(1).Range("AG7")
rCell.Offset(56, 33).FormulaR1C1 = wbResults.Sheets(1).Range("AH7")

rCell.Offset(57, 2).FormulaR1C1 = wbResults.Sheets(1).Range("c8")
rCell.Offset(57, 3).FormulaR1C1 = wbResults.Sheets(1).Range("d8")
rCell.Offset(57, 4).FormulaR1C1 = wbResults.Sheets(1).Range("e8")
rCell.Offset(57, 5).FormulaR1C1 = wbResults.Sheets(1).Range("f8")
rCell.Offset(57, 6).FormulaR1C1 = wbResults.Sheets(1).Range("g8")
rCell.Offset(57, 7).FormulaR1C1 = wbResults.Sheets(1).Range("h8")
rCell.Offset(57, 8).FormulaR1C1 = wbResults.Sheets(1).Range("i8")
rCell.Offset(57, 9).FormulaR1C1 = wbResults.Sheets(1).Range("j8")
rCell.Offset(57, 10).FormulaR1C1 = wbResults.Sheets(1).Range("k8")
rCell.Offset(57, 11).FormulaR1C1 = wbResults.Sheets(1).Range("l8")
rCell.Offset(57, 12).FormulaR1C1 = wbResults.Sheets(1).Range("m8")
rCell.Offset(57, 13).FormulaR1C1 = wbResults.Sheets(1).Range("n8")
rCell.Offset(57, 14).FormulaR1C1 = wbResults.Sheets(1).Range("o8")
rCell.Offset(57, 15).FormulaR1C1 = wbResults.Sheets(1).Range("p8")
rCell.Offset(57, 16).FormulaR1C1 = wbResults.Sheets(1).Range("q8")
rCell.Offset(57, 17).FormulaR1C1 = wbResults.Sheets(1).Range("r8")
rCell.Offset(57, 18).FormulaR1C1 = wbResults.Sheets(1).Range("s8")
rCell.Offset(57, 19).FormulaR1C1 = wbResults.Sheets(1).Range("t8")
rCell.Offset(57, 20).FormulaR1C1 = wbResults.Sheets(1).Range("u8")
rCell.Offset(57, 21).FormulaR1C1 = wbResults.Sheets(1).Range("v8")
rCell.Offset(57, 22).FormulaR1C1 = wbResults.Sheets(1).Range("w8")
rCell.Offset(57, 23).FormulaR1C1 = wbResults.Sheets(1).Range("x8")
rCell.Offset(57, 24).FormulaR1C1 = wbResults.Sheets(1).Range("y8")
rCell.Offset(57, 25).FormulaR1C1 = wbResults.Sheets(1).Range("z8")
rCell.Offset(57, 26).FormulaR1C1 = wbResults.Sheets(1).Range("AA8")
rCell.Offset(57, 27).FormulaR1C1 = wbResults.Sheets(1).Range("AB8")
rCell.Offset(57, 28).FormulaR1C1 = wbResults.Sheets(1).Range("AC8")
rCell.Offset(57, 29).FormulaR1C1 = wbResults.Sheets(1).Range("AD8")
rCell.Offset(57, 30).FormulaR1C1 = wbResults.Sheets(1).Range("AE8")
rCell.Offset(57, 31).FormulaR1C1 = wbResults.Sheets(1).Range("AF8")
rCell.Offset(57, 32).FormulaR1C1 = wbResults.Sheets(1).Range("AG8")
rCell.Offset(57, 33).FormulaR1C1 = wbResults.Sheets(1).Range("AH8")

rCell.Offset(58, 2).FormulaR1C1 = wbResults.Sheets(1).Range("c9")
rCell.Offset(58, 3).FormulaR1C1 = wbResults.Sheets(1).Range("d9")
rCell.Offset(58, 4).FormulaR1C1 = wbResults.Sheets(1).Range("e9")
rCell.Offset(58, 5).FormulaR1C1 = wbResults.Sheets(1).Range("f9")
rCell.Offset(58, 6).FormulaR1C1 = wbResults.Sheets(1).Range("g9")
rCell.Offset(58, 7).FormulaR1C1 = wbResults.Sheets(1).Range("h9")
rCell.Offset(58, 8).FormulaR1C1 = wbResults.Sheets(1).Range("i9")
rCell.Offset(58, 9).FormulaR1C1 = wbResults.Sheets(1).Range("j9")
rCell.Offset(58, 10).FormulaR1C1 = wbResults.Sheets(1).Range("k9")
rCell.Offset(58, 11).FormulaR1C1 = wbResults.Sheets(1).Range("l9")
rCell.Offset(58, 12).FormulaR1C1 = wbResults.Sheets(1).Range("m9")
rCell.Offset(58, 13).FormulaR1C1 = wbResults.Sheets(1).Range("n9")
rCell.Offset(58, 14).FormulaR1C1 = wbResults.Sheets(1).Range("o9")
rCell.Offset(58, 15).FormulaR1C1 = wbResults.Sheets(1).Range("p9")
rCell.Offset(58, 16).FormulaR1C1 = wbResults.Sheets(1).Range("q9")
rCell.Offset(58, 17).FormulaR1C1 = wbResults.Sheets(1).Range("r9")
rCell.Offset(58, 18).FormulaR1C1 = wbResults.Sheets(1).Range("s9")
rCell.Offset(58, 19).FormulaR1C1 = wbResults.Sheets(1).Range("t9")
rCell.Offset(58, 20).FormulaR1C1 = wbResults.Sheets(1).Range("u9")
rCell.Offset(58, 21).FormulaR1C1 = wbResults.Sheets(1).Range("v9")
rCell.Offset(58, 22).FormulaR1C1 = wbResults.Sheets(1).Range("w9")
rCell.Offset(58, 23).FormulaR1C1 = wbResults.Sheets(1).Range("x9")
rCell.Offset(58, 24).FormulaR1C1 = wbResults.Sheets(1).Range("y9")
rCell.Offset(58, 25).FormulaR1C1 = wbResults.Sheets(1).Range("z9")
rCell.Offset(58, 26).FormulaR1C1 = wbResults.Sheets(1).Range("AA9")
rCell.Offset(58, 27).FormulaR1C1 = wbResults.Sheets(1).Range("AB9")
rCell.Offset(58, 28).FormulaR1C1 = wbResults.Sheets(1).Range("AC9")
rCell.Offset(58, 29).FormulaR1C1 = wbResults.Sheets(1).Range("AD9")
rCell.Offset(58, 30).FormulaR1C1 = wbResults.Sheets(1).Range("AE9")
rCell.Offset(58, 31).FormulaR1C1 = wbResults.Sheets(1).Range("AF9")
rCell.Offset(58, 32).FormulaR1C1 = wbResults.Sheets(1).Range("AG9")
rCell.Offset(58, 33).FormulaR1C1 = wbResults.Sheets(1).Range("AH9")

rCell.Offset(59, 2).FormulaR1C1 = wbResults.Sheets(1).Range("c10")
rCell.Offset(59, 3).FormulaR1C1 = wbResults.Sheets(1).Range("d10")
rCell.Offset(59, 4).FormulaR1C1 = wbResults.Sheets(1).Range("e10")
rCell.Offset(59, 5).FormulaR1C1 = wbResults.Sheets(1).Range("f10")
rCell.Offset(59, 6).FormulaR1C1 = wbResults.Sheets(1).Range("g10")
rCell.Offset(59, 7).FormulaR1C1 = wbResults.Sheets(1).Range("h10")
rCell.Offset(59, 8).FormulaR1C1 = wbResults.Sheets(1).Range("i10")
rCell.Offset(59, 9).FormulaR1C1 = wbResults.Sheets(1).Range("j10")
rCell.Offset(59, 10).FormulaR1C1 = wbResults.Sheets(1).Range("k10")
rCell.Offset(59, 11).FormulaR1C1 = wbResults.Sheets(1).Range("l10")
rCell.Offset(59, 12).FormulaR1C1 = wbResults.Sheets(1).Range("m10")
rCell.Offset(59, 13).FormulaR1C1 = wbResults.Sheets(1).Range("n10")
rCell.Offset(59, 14).FormulaR1C1 = wbResults.Sheets(1).Range("o10")
rCell.Offset(59, 15).FormulaR1C1 = wbResults.Sheets(1).Range("p10")
rCell.Offset(59, 16).FormulaR1C1 = wbResults.Sheets(1).Range("q10")
rCell.Offset(59, 17).FormulaR1C1 = wbResults.Sheets(1).Range("r10")
rCell.Offset(59, 18).FormulaR1C1 = wbResults.Sheets(1).Range("s10")
rCell.Offset(59, 19).FormulaR1C1 = wbResults.Sheets(1).Range("t10")
rCell.Offset(59, 20).FormulaR1C1 = wbResults.Sheets(1).Range("u10")
rCell.Offset(59, 21).FormulaR1C1 = wbResults.Sheets(1).Range("v10")
rCell.Offset(59, 22).FormulaR1C1 = wbResults.Sheets(1).Range("w10")
rCell.Offset(59, 23).FormulaR1C1 = wbResults.Sheets(1).Range("x10")
rCell.Offset(59, 24).FormulaR1C1 = wbResults.Sheets(1).Range("y10")
rCell.Offset(59, 25).FormulaR1C1 = wbResults.Sheets(1).Range("z10")
rCell.Offset(59, 26).FormulaR1C1 = wbResults.Sheets(1).Range("AA10")
rCell.Offset(59, 27).FormulaR1C1 = wbResults.Sheets(1).Range("AB10")
rCell.Offset(59, 28).FormulaR1C1 = wbResults.Sheets(1).Range("AC10")
rCell.Offset(59, 29).FormulaR1C1 = wbResults.Sheets(1).Range("AD10")
rCell.Offset(59, 30).FormulaR1C1 = wbResults.Sheets(1).Range("AE10")
rCell.Offset(59, 31).FormulaR1C1 = wbResults.Sheets(1).Range("AF10")
rCell.Offset(59, 32).FormulaR1C1 = wbResults.Sheets(1).Range("AG10")
rCell.Offset(59, 33).FormulaR1C1 = wbResults.Sheets(1).Range("AH10")

rCell.Offset(60, 2).FormulaR1C1 = wbResults.Sheets(1).Range("c11")
rCell.Offset(60, 3).FormulaR1C1 = wbResults.Sheets(1).Range("d11")
rCell.Offset(60, 4).FormulaR1C1 = wbResults.Sheets(1).Range("e11")
rCell.Offset(60, 5).FormulaR1C1 = wbResults.Sheets(1).Range("f11")
rCell.Offset(60, 6).FormulaR1C1 = wbResults.Sheets(1).Range("g11")
rCell.Offset(60, 7).FormulaR1C1 = wbResults.Sheets(1).Range("h11")
rCell.Offset(60, 8).FormulaR1C1 = wbResults.Sheets(1).Range("i11")
rCell.Offset(60, 9).FormulaR1C1 = wbResults.Sheets(1).Range("j11")
rCell.Offset(60, 10).FormulaR1C1 = wbResults.Sheets(1).Range("k11")
rCell.Offset(60, 11).FormulaR1C1 = wbResults.Sheets(1).Range("l11")
rCell.Offset(60, 12).FormulaR1C1 = wbResults.Sheets(1).Range("m11")
rCell.Offset(60, 13).FormulaR1C1 = wbResults.Sheets(1).Range("n11")
rCell.Offset(60, 14).FormulaR1C1 = wbResults.Sheets(1).Range("o11")
rCell.Offset(60, 15).FormulaR1C1 = wbResults.Sheets(1).Range("p11")
rCell.Offset(60, 16).FormulaR1C1 = wbResults.Sheets(1).Range("q11")
rCell.Offset(60, 17).FormulaR1C1 = wbResults.Sheets(1).Range("r11")
rCell.Offset(60, 18).FormulaR1C1 = wbResults.Sheets(1).Range("s11")
rCell.Offset(60, 19).FormulaR1C1 = wbResults.Sheets(1).Range("t11")
rCell.Offset(60, 20).FormulaR1C1 = wbResults.Sheets(1).Range("u11")
rCell.Offset(60, 21).FormulaR1C1 = wbResults.Sheets(1).Range("v11")
rCell.Offset(60, 22).FormulaR1C1 = wbResults.Sheets(1).Range("w11")
rCell.Offset(60, 23).FormulaR1C1 = wbResults.Sheets(1).Range("x11")
rCell.Offset(60, 24).FormulaR1C1 = wbResults.Sheets(1).Range("y11")
rCell.Offset(60, 25).FormulaR1C1 = wbResults.Sheets(1).Range("z11")
rCell.Offset(60, 26).FormulaR1C1 = wbResults.Sheets(1).Range("AA11")
rCell.Offset(60, 27).FormulaR1C1 = wbResults.Sheets(1).Range("AB11")
rCell.Offset(60, 28).FormulaR1C1 = wbResults.Sheets(1).Range("AC11")
rCell.Offset(60, 29).FormulaR1C1 = wbResults.Sheets(1).Range("AD11")
rCell.Offset(60, 30).FormulaR1C1 = wbResults.Sheets(1).Range("AE11")
rCell.Offset(60, 31).FormulaR1C1 = wbResults.Sheets(1).Range("AF11")
rCell.Offset(60, 32).FormulaR1C1 = wbResults.Sheets(1).Range("AG11")
rCell.Offset(60, 33).FormulaR1C1 = wbResults.Sheets(1).Range("AH11")



Next lCount
End If
End With
End Sub

here is an example of the data
<TABLE style="WIDTH: 432pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=576 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" span=9 width=64><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent" width=64 height=21 x:fmla='=TEXT(A2, "ddd")'>Thu</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=64 x:fmla='=TEXT(B2, "ddd")'>Fri</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=64 x:fmla='=TEXT(C2, "ddd")'>Sat</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=64 x:fmla='=TEXT(D2, "ddd")'>Sun</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=64 x:fmla='=TEXT(E2, "ddd")'>Mon</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=64 x:fmla='=TEXT(F2, "ddd")'>Tue</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=64 x:fmla='=TEXT(G2, "ddd")'>Wed</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=64 x:fmla='=TEXT(H2, "ddd")'>Thu</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=64 x:fmla='=TEXT(I2, "ddd")'>Fri</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: silver" height=18 x:num="40269">1-Apr</TD><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: silver" x:num="40270">2-Apr</TD><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: silver" x:num="40271">3-Apr</TD><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: silver" x:num="40272">4-Apr</TD><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: silver" x:num="40273">5-Apr</TD><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: silver" x:num="40274">6-Apr</TD><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: silver" x:num="40275">7-Apr</TD><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: silver" x:num="40276">8-Apr</TD><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: silver" x:num="40277">9-Apr</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20 x:num>59</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>73</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: silver"></TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: silver"></TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>41</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>83</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>71</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>59</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>64</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20 x:num="1.5046296296296297E-4">0:00:13</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="6.9444444444444444E-5">0:00:06</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: silver"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: silver"></TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="1.273148148148148E-4">0:00:11</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="1.0416666666666667E-4">0:00:09</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="6.9444444444444444E-5">0:00:06</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="1.1574074074074073E-4">0:00:10</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="6.9444444444444444E-5">0:00:06</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20 x:num>0</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: silver"></TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: silver"></TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>2</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>1</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>1</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20 x:num>0</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: silver"></TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: silver"></TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>1</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num>0</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20 x:num="0">0:00:00</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="0">0:00:00</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: silver"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: silver"></TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="2.7777777777777778E-4">0:00:24</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="9.2592592592592588E-5">0:00:08</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="0">0:00:00</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="9.3750000000000007E-4">0:01:21</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="0">0:00:00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20 x:num="0">0:00:00</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="0">0:00:00</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: silver"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: silver"></TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="4.7453703703703704E-4">0:00:41</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="9.2592592592592588E-5">0:00:08</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="0">0:00:00</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="9.3750000000000007E-4">0:01:21</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="0">0:00:00</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20 x:num="2.2337962962962967E-3">0:03:13</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="2.0601851851851853E-3">0:02:58</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: silver"></TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: silver"></TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="2.1180555555555553E-3">0:03:03</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="2.1180555555555553E-3">0:03:03</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="1.9791666666666668E-3">0:02:51</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="2.8472222222222219E-3">0:04:06</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" x:num="2.4189814814814816E-3">0:03:29</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" height=18 x:num="3.0208333333333333E-3">0:04:21</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:num="2.9976851851851848E-3">0:04:19</TD><TD class=xl72 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl72 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #f0f0f0; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: silver"></TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:num="5.4282407407407404E-3">0:07:49</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:num="5.8796296296296296E-3">0:08:28</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:num="4.3518518518518515E-3">0:06:16</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:num="4.4212962962962956E-3">0:06:22</TD><TD class=xl71 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" x:num="2.9282407407407412E-3">0:04:13</TD></TR></TBODY></TABLE>
 
Last edited:
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
951
smozgur
smozgur
E
  • Question Question
VBA code clean up
Replies
9
Views
706
mumps
mumps
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
3K
Attrazion
A
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
E
  • Question Question
Query in excel to Outlook mail take rows with name until next name
Replies
0
Views
549
esben
E

Share this page

We've detected that you are using an adblocker.

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

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

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

Disable uBlock

Follow these easy steps to disable uBlock

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