Find and compare values from two

yard2011

New Member
Joined
Sep 28, 2011
Messages
2
Hello my friends,
I need your help with macro VBA coding in Excel 2007:
I have one workbook with three sheets:
1.texts
2.images
3.joined



sheet texts:


<TABLE style="WIDTH: 817pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1089><COLGROUP><COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1938" width=53><COL style="WIDTH: 265pt; mso-width-source: userset; mso-width-alt: 12909" width=353><COL style="WIDTH: 468pt; mso-width-source: userset; mso-width-alt: 22820" width=624><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" width=59><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 40pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=20 width=53> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 265pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 width=353> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; WIDTH: 468pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64 width=624>Vychytávky</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 44pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 width=59> </TD></TR><TR style="HEIGHT: 108pt; mso-height-source: userset" height=144><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 108pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=144>DA4781</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 265pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=353>Relaxační polštář
modrý, 32 x 27 cm spec. Mikrokuličky
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 468pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=624>Relaxační polštář je naplněn speciálními mikrokuličkami, které zajistí, že se polštářek nikdy neslehne. Vynikající, pokud vás bolí nohy – můžete si ho dát mezi kolena a lýtka a ulevíte bolesti nohou. Pěkně se na něm odpočívá (pod hlavou), protože vaši páteř vždy dostane do ideální polohy. Ideální pro těhotné ženy a osoby s žilními problémy na nohou. Speciální elastický materiál.

Polštář můžete prát v pračce na 30 °C. Doporučujeme prostředek MOHAIRA gel.
Velikost: 32x27 cm.
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65> 11,95 € </TD></TR><TR style="HEIGHT: 85.5pt; mso-height-source: userset" height=114><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 85.5pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=114>DA4782</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 265pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=353>Relaxační polštář
žlutý, 32 x 27 cm spec. mikrokuličky
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 468pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=624>Relaxační polštář je naplněn speciálními mikrokuličkami, které zajistí, že se polštářek nikdy neslehne. Vynikající, pokud vás bolí nohy – můžete si ho dát mezi kolena a lýtka a ulevíte bolesti nohou. Pěkně se na něm odpočívá (pod hlavou), protože vaši páteř vždy dostane do ideální polohy. Ideální pro těhotné ženy a osoby s žilními problémy na nohou. Speciální elastický materiál.

Polštář můžete prát v pračce na 30 °C. Doporučujeme prostředek MOHAIRA gel.
Velikost: 32x27 cm.
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65> 11,95 € </TD></TR><TR style="HEIGHT: 81.75pt; mso-height-source: userset" height=109><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 81.75pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=109>DA4783</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 265pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=353>Relaxační polštář
růžový, 32 x 27 cm spec. Mikrokuličky
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 468pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=624>Relaxační polštář je naplněn speciálními mikrokuličkami, které zajistí, že se polštářek nikdy neslehne. Vynikající, pokud vás bolí nohy – můžete si ho dát mezi kolena a lýtka a ulevíte bolesti nohou. Pěkně se na něm odpočívá (pod hlavou), protože vaši páteř vždy dostane do ideální polohy. Ideální pro těhotné ženy a osoby s žilními problémy na nohou. Speciální elastický materiál.

Polštář můžete prát v pračce na 30 °C. Doporučujeme prostředek MOHAIRA gel.
Velikost: 32x27 cm.
</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65> 11,95 € </TD></TR></TBODY></TABLE>



sheet images:​

<TABLE style="WIDTH: 454pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=604><COLGROUP><COL style="WIDTH: 100pt; mso-width-source: userset; mso-width-alt: 4864" width=133><COL style="WIDTH: 110pt; mso-width-source: userset; mso-width-alt: 5339" width=146><COL style="WIDTH: 100pt; mso-width-source: userset; mso-width-alt: 4864" width=133><COL style="WIDTH: 48pt" span=3 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 100pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20 width=133>DA4694.JPG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 110pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=146>DA4694-1.JPG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 100pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=133></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=64></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>DA4780.JPG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">DA4780-1.JPG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">DA4780-2.JPG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>DA4781.JPG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">DA4781-1.JPG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">DA4781-2.JPG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>DA4782.JPG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">DA4782-1.JPG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8">DA4782-2.JPG</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR></TBODY></TABLE>​

I need macro, module, which joined correct rows from this two sheets and write it into the row in sheet joined....

For example,

result must be in the one row as this:


<TABLE style="WIDTH: 775pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1034><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 215pt; mso-width-source: userset; mso-width-alt: 10496" width=287><COL style="WIDTH: 272pt; mso-width-source: userset; mso-width-alt: 13275" width=363><COL style="WIDTH: 48pt" span=5 width=64><TBODY><TR style="HEIGHT: 189pt; mso-height-source: userset" height=252><TD style="BORDER-BOTTOM: #3f3f3f 0.5pt solid; BORDER-LEFT: #3f3f3f 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; WIDTH: 48pt; HEIGHT: 189pt; BORDER-TOP: #3f3f3f 0.5pt solid; BORDER-RIGHT: #3f3f3f 0.5pt solid" class=xl65 height=252 width=64>DA4781</TD><TD style="BORDER-BOTTOM: #3f3f3f 0.5pt solid; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #f2f2f2; WIDTH: 215pt; BORDER-TOP: #3f3f3f 0.5pt solid; BORDER-RIGHT: #3f3f3f 0.5pt solid" class=xl66 width=287>Relaxační polštář
modrý, 32 x 27 cm spec. Mikrokuličky
</TD><TD style="BORDER-BOTTOM: #3f3f3f 0.5pt solid; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #f2f2f2; WIDTH: 272pt; BORDER-TOP: #3f3f3f 0.5pt solid; BORDER-RIGHT: #3f3f3f 0.5pt solid" class=xl66 width=363>Relaxační polštář je naplněn speciálními mikrokuličkami, které zajistí, že se polštářek nikdy neslehne. Vynikající, pokud vás bolí nohy – můžete si ho dát mezi kolena a lýtka a ulevíte bolesti nohou. Pěkně se na něm odpočívá (pod hlavou), protože vaši páteř vždy dostane do ideální polohy. Ideální pro těhotné ženy a osoby s žilními problémy na nohou. Speciální elastický materiál.

Polštář můžete prát v pračce na 30 °C. Doporučujeme prostředek MOHAIRA gel.
Velikost: 32x27 cm.
</TD><TD style="BORDER-BOTTOM: #3f3f3f 0.5pt solid; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #f2f2f2; WIDTH: 48pt; BORDER-TOP: #3f3f3f 0.5pt solid; BORDER-RIGHT: #3f3f3f 0.5pt solid" class=xl67 width=64> 11,95 € </TD><TD style="BORDER-BOTTOM: #3f3f3f 0.5pt solid; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #f2f2f2; WIDTH: 48pt; BORDER-TOP: #3f3f3f 0.5pt solid; BORDER-RIGHT: #3f3f3f 0.5pt solid" class=xl65 width=64>DA4781.JPG</TD><TD style="BORDER-BOTTOM: #3f3f3f 0.5pt solid; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #f2f2f2; WIDTH: 48pt; BORDER-TOP: #3f3f3f 0.5pt solid; BORDER-RIGHT: #3f3f3f 0.5pt solid" class=xl65 width=64>DA4781-1.JPG</TD><TD style="BORDER-BOTTOM: #3f3f3f 0.5pt solid; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #f2f2f2; WIDTH: 48pt; BORDER-TOP: #3f3f3f 0.5pt solid; BORDER-RIGHT: #3f3f3f 0.5pt solid" class=xl65 width=64>DA4781-2.JPG</TD><TD style="BORDER-BOTTOM: #3f3f3f 0.5pt solid; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #f2f2f2; WIDTH: 48pt; BORDER-TOP: #3f3f3f 0.5pt solid; BORDER-RIGHT: #3f3f3f 0.5pt solid" class=xl65 width=64> </TD></TR></TBODY></TABLE>
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,224,594
Messages
6,179,792
Members
452,942
Latest member
VijayNewtoExcel

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