copy and paste between worksheets, problem with code help

G

geordz

New Member
Joined
Apr 13, 2010
Messages
42
Hi there,
I have the following code which compares a string between two sheets. First sheet is 'data', second is 'saw'. I'm trying to copy an array of numbers (energy consumption for each hour of the day) based on machine ID and date (hence the compare string). Can someone help modify it so it will copy the array of 24 number, not just the first number?

I have a few worksheets 'saw', drill, lathe. So I am using ActiveSheet, so I can run the same macro as all data is in the 'data' worksheet. Hope someone can help

Sub test_copy()
Dim a, i As Long, txt As String
a = Sheets("data").Range("a1").CurrentRegion.Value
With CreateObject("Scripting.Dictionary")
.CompareMode = 1
For i = 1 To UBound(a, 1)
txt = a(i, 2) & ";;" & a(i, 3)
.Item(txt) = a(i, 4)
Next
a = ActiveSheet.Range("a1").CurrentRegion.Resize(, 4).Value
For i = 1 To UBound(a, 1)
txt = a(i, 1) & ";;" & a(i, 2)
If .exists(txt) Then
a(i, 4) = .Item(txt)
Else
a(i, 4) = ""
End If
Next
End With
ActiveSheet.Range("a1").CurrentRegion.Resize(, 4).Value = a
End Sub

--------------------
datasheet below
--------------------
Excel 2007
ABCDEFGHIJKLMN
sawing machine
lathe machine
drilling machine

<COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0"><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]01/10/2012[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]02/10/2012[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]03/10/2012[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]04/10/2012[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]05/10/2012[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]06/10/2012[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]07/10/2012[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]08/10/2012[/TD]
[TD="align: right"]0.8[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]09/10/2012[/TD]
[TD="align: right"]0.9[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]10/10/2012[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]11/10/2012[/TD]
[TD="align: right"]1.1[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]12/10/2012[/TD]
[TD="align: right"]1.2[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]13/10/2012[/TD]
[TD="align: right"]1.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]14/10/2012[/TD]
[TD="align: right"]1.4[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]15/10/2012[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]16/10/2012[/TD]
[TD="align: right"]1.6[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]17/10/2012[/TD]
[TD="align: right"]1.7[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]18/10/2012[/TD]
[TD="align: right"]1.8[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]19/10/2012[/TD]
[TD="align: right"]1.9[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]21[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]20/10/2012[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]22[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]21/10/2012[/TD]
[TD="align: right"]2.1[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]23[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]22/10/2012[/TD]
[TD="align: right"]2.2[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]24[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]01/10/2012[/TD]
[TD="align: right"]3.1[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]26[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]02/10/2012[/TD]
[TD="align: right"]3.2[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]27[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]03/10/2012[/TD]
[TD="align: right"]3.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]28[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]04/10/2012[/TD]
[TD="align: right"]3.4[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]29[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]05/10/2012[/TD]
[TD="align: right"]3.5[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]30[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]06/10/2012[/TD]
[TD="align: right"]3.6[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]31[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]07/10/2012[/TD]
[TD="align: right"]3.7[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]32[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]08/10/2012[/TD]
[TD="align: right"]3.8[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]33[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]09/10/2012[/TD]
[TD="align: right"]3.9[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]34[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]10/10/2012[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]35[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]11/10/2012[/TD]
[TD="align: right"]4.1[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]36[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]12/10/2012[/TD]
[TD="align: right"]4.2[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]37[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]13/10/2012[/TD]
[TD="align: right"]4.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]38[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]14/10/2012[/TD]
[TD="align: right"]4.4[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]39[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]15/10/2012[/TD]
[TD="align: right"]4.5[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]40[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]16/10/2012[/TD]
[TD="align: right"]4.6[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]41[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]17/10/2012[/TD]
[TD="align: right"]4.7[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]42[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]18/10/2012[/TD]
[TD="align: right"]4.8[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]43[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]19/10/2012[/TD]
[TD="align: right"]4.9[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]44[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]20/10/2012[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]45[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]21/10/2012[/TD]
[TD="align: right"]5.1[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]46[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100256[/TD]
[TD="align: right"]22/10/2012[/TD]
[TD="align: right"]5.2[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]47[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]48[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]01/10/2012[/TD]
[TD="align: right"]6.1[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]49[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]02/10/2012[/TD]
[TD="align: right"]6.2[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]50[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]03/10/2012[/TD]
[TD="align: right"]6.3[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]51[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]04/10/2012[/TD]
[TD="align: right"]6.4[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]52[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]05/10/2012[/TD]
[TD="align: right"]6.5[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]53[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]06/10/2012[/TD]
[TD="align: right"]6.6[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]54[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]07/10/2012[/TD]
[TD="align: right"]6.7[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]55[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]08/10/2012[/TD]
[TD="align: right"]6.8[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]56[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]09/10/2012[/TD]
[TD="align: right"]6.9[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]57[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]10/10/2012[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]58[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]11/10/2012[/TD]
[TD="align: right"]7.1[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]59[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]12/10/2012[/TD]
[TD="align: right"]7.2[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]60[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]13/10/2012[/TD]
[TD="align: right"]7.3[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]61[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]14/10/2012[/TD]
[TD="align: right"]7.4[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]62[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]15/10/2012[/TD]
[TD="align: right"]7.5[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]63[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]16/10/2012[/TD]
[TD="align: right"]7.6[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]64[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]17/10/2012[/TD]
[TD="align: right"]7.7[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]65[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]18/10/2012[/TD]
[TD="align: right"]7.8[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]66[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]19/10/2012[/TD]
[TD="align: right"]7.9[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]67[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]20/10/2012[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]68[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]21/10/2012[/TD]
[TD="align: right"]8.1[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

[TD="align: center"]69[/TD]
[TD="align: right"][/TD]
[TD="align: right"]45896[/TD]
[TD="align: right"]22/10/2012[/TD]
[TD="align: right"]8.2[/TD]
[TD="align: right"]1.25[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]0.22[/TD]
[TD="align: right"]0.14[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.45[/TD]
[TD="align: right"]0.47[/TD]

</TBODY>
data​



-----------------------
machine sheet
-----------------------

Excel 2007
ABC

<COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0"><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
[TD="align: center"]1[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]23/09/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]24/09/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]25/09/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]26/09/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]27/09/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]28/09/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]29/09/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]30/09/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]01/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]02/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]03/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]04/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]05/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]06/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]07/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]08/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]09/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]10/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]11/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]12/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]13/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]14/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]15/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]16/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]17/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]18/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]27[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]19/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]28[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]20/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]29[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]21/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]30[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]22/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]31[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]23/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]32[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]24/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]33[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]25/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]34[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]26/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]35[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]27/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]36[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]28/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]37[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]29/10/2010[/TD]
[TD="align: right"][/TD]

[TD="align: center"]38[/TD]
[TD="align: right"]100569[/TD]
[TD="align: right"]30/10/2010[/TD]
[TD="align: right"][/TD]

</TBODY>
saw​



cheers
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Sort by date Sort by votes
Hi there,
Is anyone able to help me out or see an obvious mistake as to why the macro does not work please?

much appreciate any help
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Macro getting stuck on average when no data is present
Replies
5
Views
421
amphead
A
1
  • Question Question
Calculate on every third Friday of the month and show results between positive & negative weeks
2
Replies
14
Views
952
15minoffame
1
X
  • Question Question
Conditional formatting cells up to first cell after group of consecutive zeros
Replies
1
Views
464
awoohaw
awoohaw
S
  • Question Question
Date column not working
Replies
4
Views
679
awoohaw
awoohaw
G
  • Question Question
Complex problem - how many widgets should I sell?
Replies
9
Views
638
Dan_W
D

Forum statistics

Threads
1,223,713
Messages
6,174,041
Members
452,542
Latest member
Bricklin

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