VBA Macro Problem

[Excel_Assis]

Hi can someone quickly help fix a VBA macro problem. When running the VBA macro below on sheet1 data it generates the correct result but places the result in the wrong place on sheet2 the summary page. The result has to be placed in certain columns with no cell formating. The ACC No. result data needs to be in column F and the Job No data result needs to be in column G.



Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 68px"><COL style="WIDTH: 67px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">DATE</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">ITEM</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">ACC No.</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">US$</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">RECEIPT</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">JOB NO. A</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">JOB A US$</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">JOB NO. B</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">JOB B US$</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt">Cat</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10005</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$5.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$5.00</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">Yes</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$2.50</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt">9876</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt">$2.50</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt">Dog</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$87.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$87.00</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">No</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$87.00</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt">Rat</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10006</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$23.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$23.00</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">No</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$23.00</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt">Pig</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10008</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$56.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$56.00</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$56.00</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt">Rat</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10006</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$4.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$4.00</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$4.00</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt">Dog</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$6.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$6.00</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">Yes</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt">9876</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt">$6.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt">Dog</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$98.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$98.00</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$98.00</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt">Pig</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10008</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$23.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$23.00</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">No</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt">9876</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt">$23.00</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt">Cat</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10005</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$21.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$21.00</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">Yes</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$21.00</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt">Dog</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$65.00</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$65.00</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">6789</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">$65.00</TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 10pt">$0.00</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #ccffcc; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="BACKGROUND-COLOR: #ccccff"></TD><TD style="BACKGROUND-COLOR: #ccccff"></TD><TD></TD><TD style="BACKGROUND-COLOR: #c0c0c0"></TD><TD style="BACKGROUND-COLOR: #c0c0c0"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="BACKGROUND-COLOR: #ccccff"></TD><TD style="BACKGROUND-COLOR: #ccccff"></TD><TD></TD><TD style="BACKGROUND-COLOR: #c0c0c0"></TD><TD style="BACKGROUND-COLOR: #c0c0c0"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="BACKGROUND-COLOR: #ccccff"></TD><TD style="BACKGROUND-COLOR: #ccccff"></TD><TD></TD><TD style="BACKGROUND-COLOR: #c0c0c0"></TD><TD style="BACKGROUND-COLOR: #c0c0c0"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="BACKGROUND-COLOR: #ccccff"></TD><TD style="BACKGROUND-COLOR: #ccccff"></TD><TD></TD><TD style="BACKGROUND-COLOR: #c0c0c0"></TD><TD style="BACKGROUND-COLOR: #c0c0c0"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="BACKGROUND-COLOR: #ccccff"></TD><TD style="BACKGROUND-COLOR: #ccccff"></TD><TD></TD><TD style="BACKGROUND-COLOR: #c0c0c0"></TD><TD style="BACKGROUND-COLOR: #c0c0c0"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD style="BACKGROUND-COLOR: #ccccff"></TD><TD style="BACKGROUND-COLOR: #ccccff"></TD><TD></TD><TD style="BACKGROUND-COLOR: #c0c0c0"></TD><TD style="BACKGROUND-COLOR: #c0c0c0"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD><TD style="BACKGROUND-COLOR: #ccffcc"></TD></TR></TBODY></TABLE>

Macro run on above data.

Sub Advanced_Filter_Sort_Summary()
Dim wsSrc As Worksheet: Set wsSrc = Sheets("Sheet1")
Dim wsDest As Worksheet: Set wsDest = Sheets("Sheet2")
Dim i As Long
With wsDest
.UsedRange.Clear
wsSrc.Range("B8:B25,E8:E25,I8:I25,K8:K25").Copy .Range("B1")

For i = 2 To .Range("B" & .Rows.Count).End(xlUp).Row
If .Range("E" & i).Value <> "" Then
.Range("E" & i).Offset(0, -1).Value = .Range("E" & i).Value
End If
Next i

.Columns("E").Delete
.Range("B1:D12").AdvancedFilter Action:=xlFilterCopy, _
CopyToRange:=.Range("E1"), Unique:=True
.Columns("B:D").Delete
End With

With wsDest.Sort
.SortFields.Clear
.SortFields.Add _
Key:=Range("B1:B" & Cells(Rows.Count, "B").End(xlUp).Row), _
SortOn:=xlSortOnValues, _
Order:=xlAscending, _
DataOption:= _
xlSortTextAsNumbers
.SetRange Range("B1:D" & Cells(Rows.Count, "B").End(xlUp).Row)
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Application.GoTo Range("A1")


Set wsSrc = Nothing
Set wsDest = Nothing
End Sub



Result from macro. Correct data but Incorrect placement on sheet2.

Sheet2

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>B</TD><TD>C</TD><TD>D</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">ITEM</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">ACC No.</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-SIZE: 10pt; FONT-WEIGHT: bold">JOB NO. A</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-SIZE: 10pt">Cat</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10005</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">9876</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-SIZE: 10pt">Cat</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10005</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-SIZE: 10pt">Dog</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="FONT-SIZE: 10pt">Dog</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">9876</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="FONT-SIZE: 10pt">Dog</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">6789</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="FONT-SIZE: 10pt">Pig</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10008</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="FONT-SIZE: 10pt">Pig</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10008</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">9876</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="FONT-SIZE: 10pt">Rat</TD><TD style="TEXT-ALIGN: center; FONT-SIZE: 10pt">10006</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt">1234</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="FONT-SIZE: 10pt"></TD><TD style="FONT-SIZE: 10pt"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 10pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE>




Example of correct placement on sheet2.



Sheet2

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD></TR><TR style="HEIGHT: 19px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-WEIGHT: bold">ITEM</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-WEIGHT: bold"> </TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-WEIGHT: bold"> </TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-WEIGHT: bold"> </TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-WEIGHT: bold">Acc No</TD><TD style="BACKGROUND-COLOR: #33cccc; COLOR: #ffffff; FONT-WEIGHT: bold">Job No.</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD>Cat</TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10005</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">1234</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD>Cat</TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10005</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">9876</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD>Dog</TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">1234</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD>Dog</TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">9876</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: left">Dog</TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10003</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">6789</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: left">Pig</TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10008</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">1234</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: left">Pig</TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10008</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">9876</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: left">Rat</TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff">10006</TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0">1234</TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4