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:

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
You must log in or register to reply here.

Similar threads

A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
854
gvsumich
G
E
  • Question
Query in excel to Outlook mail take rows with name until next name
Replies
0
Views
357
esben
E
E
  • Question
VBA for Web Scraping help
Replies
0
Views
606
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C

Forum statistics

Threads
1,215,523
Messages
6,125,318
Members
449,218
Latest member
Excel Master

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