Hi everyone,
I need some help with code modification to make sure that 2 tables on the left with different values would be filled independently based on the data from the tables on the right:
[TABLE="width: 768"]
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl72, width: 64"]num[/TD]
[TD="class: xl72, width: 64"]a[/TD]
[TD="class: xl72, width: 64"]b[/TD]
[TD="class: xl72, width: 64"]c[/TD]
[TD="class: xl72, width: 64"]d[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="class: xl72, width: 64"]num[/TD]
[TD="class: xl72, width: 64"]a[/TD]
[TD="class: xl72, width: 64"]b[/TD]
[TD="class: xl72, width: 64"]c[/TD]
[TD="class: xl72, width: 64"]d[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1506[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1507[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1507[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1509[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1508[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1510[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1509[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1511[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1510[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1601[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1511[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1602[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]1512[/TD]
[TD="class: xl69, width: 64"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1603[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1601[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1604[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1602[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1605[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1603[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1604[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1605[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl72"]num[/TD]
[TD="class: xl72"]a[/TD]
[TD="class: xl72"]b[/TD]
[TD="class: xl72"]c[/TD]
[TD="class: xl72"]d[/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl72"]num[/TD]
[TD="class: xl72"]a[/TD]
[TD="class: xl72"]b[/TD]
[TD="class: xl72"]c[/TD]
[TD="class: xl72"]d[/TD]
[/TR]
[TR]
[TD="class: xl71"]1506[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1511[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1507[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1601[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl71"]1508[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1603[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1509[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1605[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1510[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1511[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1512[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1601[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1602[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1603[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1604[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1605[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I got a code that would do it if I have only one table on the left that needed to be filled with the data from the right table:
LR = Cells(Rows.Count, 8).End(xlUp).Row
For Count = LR To 2 Step -1
Z = Columns(1).Find(Cells(Count, 8), LookIn:=xlFormulas, Lookat:=xlWhole).Row
Range("H" & Count & ":A" & Count).Copy Destination:=Range("A" & Z)
Could anyone modify this part that the code would do it for both tables separably?
Thank you
I need some help with code modification to make sure that 2 tables on the left with different values would be filled independently based on the data from the tables on the right:
[TABLE="width: 768"]
<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl72, width: 64"]num[/TD]
[TD="class: xl72, width: 64"]a[/TD]
[TD="class: xl72, width: 64"]b[/TD]
[TD="class: xl72, width: 64"]c[/TD]
[TD="class: xl72, width: 64"]d[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="class: xl72, width: 64"]num[/TD]
[TD="class: xl72, width: 64"]a[/TD]
[TD="class: xl72, width: 64"]b[/TD]
[TD="class: xl72, width: 64"]c[/TD]
[TD="class: xl72, width: 64"]d[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1506[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1507[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1507[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1509[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1508[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1510[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1509[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1511[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1510[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1601[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1511[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1602[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl69, width: 64"]1512[/TD]
[TD="class: xl69, width: 64"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1603[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1601[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1604[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1602[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl68, align: right"]1605[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1603[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1604[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl68, align: right"]1605[/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD="class: xl68"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl72"]num[/TD]
[TD="class: xl72"]a[/TD]
[TD="class: xl72"]b[/TD]
[TD="class: xl72"]c[/TD]
[TD="class: xl72"]d[/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl72"]num[/TD]
[TD="class: xl72"]a[/TD]
[TD="class: xl72"]b[/TD]
[TD="class: xl72"]c[/TD]
[TD="class: xl72"]d[/TD]
[/TR]
[TR]
[TD="class: xl71"]1506[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1511[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1507[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1601[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl71"]1508[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1603[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1509[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1605[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1510[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1511[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1512[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1601[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1602[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1603[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1604[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl71"]1605[/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD="class: xl70"] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I got a code that would do it if I have only one table on the left that needed to be filled with the data from the right table:
LR = Cells(Rows.Count, 8).End(xlUp).Row
For Count = LR To 2 Step -1
Z = Columns(1).Find(Cells(Count, 8), LookIn:=xlFormulas, Lookat:=xlWhole).Row
Range("H" & Count & ":A" & Count).Copy Destination:=Range("A" & Z)
Could anyone modify this part that the code would do it for both tables separably?
Thank you