extract data from different worksheets and summarises match data on another sheet format

R

RAM1972

Board Regular
Joined
Jun 29, 2014
Messages
217
Hi:confused::confused::mad::mad:


Requires to match codes on summary sheet with a database on a match report sheet.

Actually I am doing this manually and would like to this in excel

Annexed sample

Summary

*ABCDEFG
Page Line
3CINTRECROCHET+1GRT OXYDEBLC *FRANCE * * * * * * *
XA1 BRASSIERE SPORT JAUNE FLU ROUMANIE * * * * * *
XY3 BRAS SS COUT MARINE * * * ROUMANIE * * * * * *
XY3 TOP SS COUTURE IVOIRE * * ROUMANIE * * * * * *
XY3 TOP SS COUTURE MARINE * * ROUMANIE * * * * * *
XY3 SH SS COUTURE IVOIRE * * *ROUMANIE * * * * * *
XY3 SH SS COUTURE MARINE * * *ROUMANIE * * * * * *
XY3 BRAS SS COUT IVOIRE * * * ROUMANIE * * * * * *

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:46px;"><col style="width:99px;"><col style="width:56px;"><col style="width:254px;"><col style="width:119px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="align: center"]rayon[/TD]
[TD="align: center"]ean[/TD]
[TD="align: center"]msi[/TD]
[TD="align: center"]Désignation[/TD]
[TD="align: center"]Origine[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"]3612301904511[/TD]
[TD="align: center"]3147147[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]3612302040034[/TD]
[TD="align: center"]1112481[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]3612301842769[/TD]
[TD="align: center"]966812[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]3612301843056[/TD]
[TD="align: center"]968321[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]3612301843049[/TD]
[TD="align: center"]967208[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]3612301842936[/TD]
[TD="align: center"]967158[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]3612301842929[/TD]
[TD="align: center"]967117[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]3612301842813[/TD]
[TD="align: center"]966887[/TD]

</tbody>


Excel tables to the web >> Excel Jeanie HTML 4


Database for matching

Detailed Database

*ABCDEFGHIJKLMNOPQRST
ModèleCouleurFamille_
AAAAA3 BOXERS 9J * * * * *560 4-5AE31550000 * * * * 3 BOXERS 9JE31550000 * * * * 3 BOXERS 9J * * * * *560ENFANT * * * * * * * * * * * * * * * * * * * * * * * * * * *31 55 * * SOUS-VET.GARC.4/16AN * * * * * * * * * * * * * * * * * * * *SOUS-VETEMENT GARCON * * * * * * * * * * * * * * * * * * * *BAS * * * * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAA3 BOXERS 9J * * * * *560 6-8AE31550000 * * * * 3 BOXERS 9JE31550000 * * * * 3 BOXERS 9J * * * * *560ENFANT * * * * * * * * * * * * * * * * * * * * * * * * * * *31 55 * * SOUS-VET.GARC.4/16AN * * * * * * * * * * * * * * * * * * * *SOUS-VETEMENT GARCON * * * * * * * * * * * * * * * * * * * *BAS * * * * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAA3 BOXERS 9J * * * * *560 10-12E31550000 * * * * 3 BOXERS 9JE31550000 * * * * 3 BOXERS 9J * * * * *560ENFANT * * * * * * * * * * * * * * * * * * * * * * * * * * *31 55 * * SOUS-VET.GARC.4/16AN * * * * * * * * * * * * * * * * * * * *SOUS-VETEMENT GARCON * * * * * * * * * * * * * * * * * * * *BAS * * * * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAA3 BOXERS 9J * * * * *560 14-16E31550000 * * * * 3 BOXERS 9JE31550000 * * * * 3 BOXERS 9J * * * * *560ENFANT * * * * * * * * * * * * * * * * * * * * * * * * * * *31 55 * * SOUS-VET.GARC.4/16AN * * * * * * * * * * * * * * * * * * * *SOUS-VETEMENT GARCON * * * * * * * * * * * * * * * * * * * *BAS * * * * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAA3 BOXERS 9J * * * * *510 4-5AE31550000 * * * * 3 BOXERS 9JE31550000 * * * * 3 BOXERS 9J * * * * *510ENFANT * * * * * * * * * * * * * * * * * * * * * * * * * * *31 55 * * SOUS-VET.GARC.4/16AN * * * * * * * * * * * * * * * * * * * *SOUS-VETEMENT GARCON * * * * * * * * * * * * * * * * * * * *BAS * * * * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAA3 BOXERS 9J * * * * *510 6-8AE31550000 * * * * 3 BOXERS 9JE31550000 * * * * 3 BOXERS 9J * * * * *510ENFANT * * * * * * * * * * * * * * * * * * * * * * * * * * *31 55 * * SOUS-VET.GARC.4/16AN * * * * * * * * * * * * * * * * * * * *SOUS-VETEMENT GARCON * * * * * * * * * * * * * * * * * * * *BAS * * * * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAA3 BOXERS 9J * * * * *510 10-12E31550000 * * * * 3 BOXERS 9JE31550000 * * * * 3 BOXERS 9J * * * * *510ENFANT * * * * * * * * * * * * * * * * * * * * * * * * * * *31 55 * * SOUS-VET.GARC.4/16AN * * * * * * * * * * * * * * * * * * * *SOUS-VETEMENT GARCON * * * * * * * * * * * * * * * * * * * *BAS * * * * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAA3 BOXERS 9J * * * * *510 14-16E31550000 * * * * 3 BOXERS 9JE31550000 * * * * 3 BOXERS 9J * * * * *510ENFANT * * * * * * * * * * * * * * * * * * * * * * * * * * *31 55 * * SOUS-VET.GARC.4/16AN * * * * * * * * * * * * * * * * * * * *SOUS-VETEMENT GARCON * * * * * * * * * * * * * * * * * * * *BAS * * * * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAAXXBIG TEE BANDANA * *360 38-40E33112300 * * * * XXBIG TEE BANDANAE33112300 * * * * XXBIG TEE BANDANA * *360LINGERIE * * * * * * * * * * * * * * * * * * * * * * * * * *CHEMISES DE NUIT * * * * * * * * * * * * * * * * * * * * * *CHEMISE DE NUIT * * * * * * * * * * * * * * * * * * * * * * CLASSIQUE * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAAXXBIG TEE BANDANA * *360 42-44E33112300 * * * * XXBIG TEE BANDANAE33112300 * * * * XXBIG TEE BANDANA * *360LINGERIE * * * * * * * * * * * * * * * * * * * * * * * * * *CHEMISES DE NUIT * * * * * * * * * * * * * * * * * * * * * *CHEMISE DE NUIT * * * * * * * * * * * * * * * * * * * * * * CLASSIQUE * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAAXXBIG TEE BANDANA * *360 46-48E33112300 * * * * XXBIG TEE BANDANAE33112300 * * * * XXBIG TEE BANDANA * *360LINGERIE * * * * * * * * * * * * * * * * * * * * * * * * * *CHEMISES DE NUIT * * * * * * * * * * * * * * * * * * * * * *CHEMISE DE NUIT * * * * * * * * * * * * * * * * * * * * * * CLASSIQUE * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAAXXBIG TEE BANDANA * *360 50-52E33112300 * * * * XXBIG TEE BANDANAE33112300 * * * * XXBIG TEE BANDANA * *360LINGERIE * * * * * * * * * * * * * * * * * * * * * * * * * *CHEMISES DE NUIT * * * * * * * * * * * * * * * * * * * * * *CHEMISE DE NUIT * * * * * * * * * * * * * * * * * * * * * * CLASSIQUE * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAALOT 2 CALECON Promo2 N00 SE36204401 * * * * LOT 2 CALECON Promo2E36204401 * * * * LOT 2 CALECON Promo2 N00HOMME * * * * * * * * * * * * * * * * * * * * * * * * * * * 36 20 * * SOUS-VETEMENTS * * * * * * * * * * * * * * * * * * * * * * *SOUS VETEMENTS BAS * * * * * * * * * * * * * * * * * * * * *CALECONS * * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAALOT 2 CALECON Promo2 N00 ME36204401 * * * * LOT 2 CALECON Promo2E36204401 * * * * LOT 2 CALECON Promo2 N00HOMME * * * * * * * * * * * * * * * * * * * * * * * * * * * 36 20 * * SOUS-VETEMENTS * * * * * * * * * * * * * * * * * * * * * * *SOUS VETEMENTS BAS * * * * * * * * * * * * * * * * * * * * *CALECONS * * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAALOT 2 CALECON Promo2 N00 LE36204401 * * * * LOT 2 CALECON Promo2E36204401 * * * * LOT 2 CALECON Promo2 N00HOMME * * * * * * * * * * * * * * * * * * * * * * * * * * * 36 20 * * SOUS-VETEMENTS * * * * * * * * * * * * * * * * * * * * * * *SOUS VETEMENTS BAS * * * * * * * * * * * * * * * * * * * * *CALECONS * * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAALOT 2 CALECON Promo2 N00 XLE36204401 * * * * LOT 2 CALECON Promo2E36204401 * * * * LOT 2 CALECON Promo2 N00HOMME * * * * * * * * * * * * * * * * * * * * * * * * * * * 36 20 * * SOUS-VETEMENTS * * * * * * * * * * * * * * * * * * * * * * *SOUS VETEMENTS BAS * * * * * * * * * * * * * * * * * * * * *CALECONS * * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAALOT 2 CALECON Promo2 N00 XXLE36204401 * * * * LOT 2 CALECON Promo2E36204401 * * * * LOT 2 CALECON Promo2 N00HOMME * * * * * * * * * * * * * * * * * * * * * * * * * * * 36 20 * * SOUS-VETEMENTS * * * * * * * * * * * * * * * * * * * * * * *SOUS VETEMENTS BAS * * * * * * * * * * * * * * * * * * * * *CALECONS * * * * * * * * * * * * * * * * * * * * * * * * * *

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:35px;"><col style="width:85px;"><col style="width:84px;"><col style="width:99px;"><col style="width:99px;"><col style="width:240px;"><col style="width:109px;"><col style="width:174px;"><col style="width:109px;"><col style="width:189px;"><col style="width:52px;"><col style="width:281px;"><col style="width:59px;"><col style="width:365px;"><col style="width:60px;"><col style="width:308px;"><col style="width:89px;"><col style="width:329px;"><col style="width:82px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="bgcolor: #ffff00"]Position[/TD]
[TD="bgcolor: #ffff00"]ctm[/TD]
[TD="bgcolor: #ffff00"]mag[/TD]
[TD="bgcolor: #ffff00"]MSI[/TD]
[TD="bgcolor: #ffff00"]Ean Colis[/TD]
[TD="bgcolor: #ffff00"]Ean VENTES[/TD]
[TD="bgcolor: #ffff00"]Libellé_Réf[/TD]
[TD="bgcolor: #ffff00"]Modèle[/TD]
[TD="bgcolor: #ffff00"]Modèle[/TD]
[TD="bgcolor: #ffff00"]ModèleCouleur[/TD]

[TD="bgcolor: #ffff00"]Rayon_[/TD]
[TD="bgcolor: #ffff00"]type[/TD]
[TD="bgcolor: #ffff00"]UG[/TD]
[TD="bgcolor: #ffff00"]UG[/TD]

[TD="bgcolor: #ffff00"]Famille_[/TD]
[TD="bgcolor: #ffff00"]Sous_Famille[/TD]
[TD="bgcolor: #ffff00"]Sous_Famille[/TD]
[TD="bgcolor: #ffff00"]N° de facture[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]0219006 * * * [/TD]
[TD="align: right"]3612302008454[/TD]
[TD="align: right"]3612301607498[/TD]

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

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

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

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

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]0219014 * * * [/TD]
[TD="align: right"]3612302008454[/TD]
[TD="align: right"]3612301607504[/TD]

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

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

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

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

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]0219147 * * * [/TD]
[TD="align: right"]3612302008454[/TD]
[TD="align: right"]3612301607511[/TD]

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

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

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

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

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]0219170 * * * [/TD]
[TD="align: right"]3612302008454[/TD]
[TD="align: right"]3612301607528[/TD]

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

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

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

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

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]0219238 * * * [/TD]
[TD="align: right"]3612302008454[/TD]
[TD="align: right"]3612301607535[/TD]

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

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

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

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

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]0219311 * * * [/TD]
[TD="align: right"]3612302008454[/TD]
[TD="align: right"]3612301607542[/TD]

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

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

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

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

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]0219600 * * * [/TD]
[TD="align: right"]3612302008454[/TD]
[TD="align: right"]3612301607559[/TD]

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

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

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

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

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]0219618 * * * [/TD]
[TD="align: right"]3612302008454[/TD]
[TD="align: right"]3612301607566[/TD]

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

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

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

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

[TD="bgcolor: #cacaca, align: center"]10[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]5885132 * * * [/TD]
[TD="align: right"]3612301710532[/TD]
[TD="align: right"]3612301710495[/TD]

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

[TD="align: right"]33 11 * * [/TD]

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

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

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

[TD="bgcolor: #cacaca, align: center"]11[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]5887005 * * * [/TD]
[TD="align: right"]3612301710532[/TD]
[TD="align: right"]3612301710501[/TD]

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

[TD="align: right"]33 11 * * [/TD]

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

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

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

[TD="bgcolor: #cacaca, align: center"]12[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]5887211 * * * [/TD]
[TD="align: right"]3612301710532[/TD]
[TD="align: right"]3612301710518[/TD]

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

[TD="align: right"]33 11 * * [/TD]

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

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

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

[TD="bgcolor: #cacaca, align: center"]13[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]5887450 * * * [/TD]
[TD="align: right"]3612301710532[/TD]
[TD="align: right"]3612301710525[/TD]

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

[TD="align: right"]33 11 * * [/TD]

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

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

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

[TD="bgcolor: #cacaca, align: center"]14[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]3853298 * * * [/TD]
[TD="align: right"]3612301713946[/TD]
[TD="align: right"]3612301713892[/TD]

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

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

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

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

[TD="bgcolor: #cacaca, align: center"]15[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]3853306 * * * [/TD]
[TD="align: right"]3612301713946[/TD]
[TD="align: right"]3612301713908[/TD]

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

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

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

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

[TD="bgcolor: #cacaca, align: center"]16[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]3853314 * * * [/TD]
[TD="align: right"]3612301713946[/TD]
[TD="align: right"]3612301713915[/TD]

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

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

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

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

[TD="bgcolor: #cacaca, align: center"]17[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]3853322 * * * [/TD]
[TD="align: right"]3612301713946[/TD]
[TD="align: right"]3612301713922[/TD]

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

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

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

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

[TD="bgcolor: #cacaca, align: center"]18[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]3853330 * * * [/TD]
[TD="align: right"]3612301713946[/TD]
[TD="align: right"]3612301713939[/TD]

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

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

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

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

</tbody>


Excel tables to the web >> Excel Jeanie HTML 4


Report on another sheet


Matching Report

*ABCDEFGHIJKLMNOPQRST
*Page Line ************
*VENTILATEUR TABLE 30 VENTILATECHINE * * * * * * * ************
*XXBIG TEE BANDANA CORAIL * * *BENGLADESH * * * * *************
********************
********************
ModèleCouleurFamille_
********************
*ctmmagMSIEan VENTESLibellé_RéfModèleModèleModèleCouleurModèleCouleurRayon_typeUGUGFamille_Famille_Sous_FamilleSous_FamilleN° de facture
**AAAAAno match no match no match no match no match no match no match no match no match no match no match no match no match no match no match no match no match
********************
AAAAAXXBIG TEE BANDANA * *360 38-40E33112300 * * * * XXBIG TEE BANDANAE33112300 * * * * XXBIG TEE BANDANA * *360LINGERIE * * * * * * * * * * * * * * * * * * * * * * * * * *CHEMISES DE NUIT * * * * * * * * * * * * * * * * * * * * * *CHEMISE DE NUIT * * * * * * * * * * * * * * * * * * * * * * CLASSIQUE * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAAXXBIG TEE BANDANA * *360 42-44E33112300 * * * * XXBIG TEE BANDANAE33112300 * * * * XXBIG TEE BANDANA * *360LINGERIE * * * * * * * * * * * * * * * * * * * * * * * * * *CHEMISES DE NUIT * * * * * * * * * * * * * * * * * * * * * *CHEMISE DE NUIT * * * * * * * * * * * * * * * * * * * * * * CLASSIQUE * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAAXXBIG TEE BANDANA * *360 46-48E33112300 * * * * XXBIG TEE BANDANAE33112300 * * * * XXBIG TEE BANDANA * *360LINGERIE * * * * * * * * * * * * * * * * * * * * * * * * * *CHEMISES DE NUIT * * * * * * * * * * * * * * * * * * * * * *CHEMISE DE NUIT * * * * * * * * * * * * * * * * * * * * * * CLASSIQUE * * * * * * * * * * * * * * * * * * * * * * * * *
AAAAAXXBIG TEE BANDANA * *360 50-52E33112300 * * * * XXBIG TEE BANDANAE33112300 * * * * XXBIG TEE BANDANA * *360LINGERIE * * * * * * * * * * * * * * * * * * * * * * * * * *CHEMISES DE NUIT * * * * * * * * * * * * * * * * * * * * * *CHEMISE DE NUIT * * * * * * * * * * * * * * * * * * * * * * CLASSIQUE * * * * * * * * * * * * * * * * * * * * * * * * *

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:58px;"><col style="width:52px;"><col style="width:84px;"><col style="width:99px;"><col style="width:99px;"><col style="width:254px;"><col style="width:119px;"><col style="width:64px;"><col style="width:84px;"><col style="width:180px;"><col style="width:99px;"><col style="width:128px;"><col style="width:217px;"><col style="width:64px;"><col style="width:141px;"><col style="width:308px;"><col style="width:183px;"><col style="width:145px;"><col style="width:99px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="align: center"]rayon[/TD]
[TD="bgcolor: #0066cc, align: center"]ean[/TD]
[TD="align: center"]msi[/TD]
[TD="align: center"]Désignation[/TD]
[TD="align: center"]Origine[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]3121040031643[/TD]
[TD="align: center"]5232426[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]3612301710532[/TD]
[TD="align: center"]1216100[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="bgcolor: #ffff00"]Position[/TD]
[TD="bgcolor: #ffff00"]ctm[/TD]
[TD="bgcolor: #ffff00"]mag[/TD]
[TD="bgcolor: #ffff00"]MSI[/TD]
[TD="bgcolor: #ffff00"]Ean Colis[/TD]
[TD="bgcolor: #ffff00"]Ean VENTES[/TD]
[TD="bgcolor: #ffff00"]Libellé_Réf[/TD]
[TD="bgcolor: #ffff00"]Modèle[/TD]
[TD="bgcolor: #ffff00"]Modèle[/TD]
[TD="bgcolor: #ffff00"]ModèleCouleur[/TD]

[TD="bgcolor: #ffff00"]Rayon_[/TD]
[TD="bgcolor: #ffff00"]type[/TD]
[TD="bgcolor: #ffff00"]UG[/TD]
[TD="bgcolor: #ffff00"]UG[/TD]

[TD="bgcolor: #ffff00"]Famille_[/TD]
[TD="bgcolor: #ffff00"]Sous_Famille[/TD]
[TD="bgcolor: #ffff00"]Sous_Famille[/TD]
[TD="bgcolor: #ffff00"]N° de facture[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]

[TD="bgcolor: #0066cc"]Ean Colis[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]5885132 * * * [/TD]
[TD="align: right"]3612301710532[/TD]
[TD="align: right"]3612301710495[/TD]

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

[TD="align: right"]33 11 * * [/TD]

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

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

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

[TD="bgcolor: #cacaca, align: center"]12[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]5887005 * * * [/TD]
[TD="align: right"]3612301710532[/TD]
[TD="align: right"]3612301710501[/TD]

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

[TD="align: right"]33 11 * * [/TD]

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

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

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

[TD="bgcolor: #cacaca, align: center"]13[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]5887211 * * * [/TD]
[TD="align: right"]3612301710532[/TD]
[TD="align: right"]3612301710518[/TD]

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

[TD="align: right"]33 11 * * [/TD]

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

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

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

[TD="bgcolor: #cacaca, align: center"]14[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]3216[/TD]

[TD="align: right"]5887450 * * * [/TD]
[TD="align: right"]3612301710532[/TD]
[TD="align: right"]3612301710525[/TD]

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

[TD="align: right"]33 11 * * [/TD]

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

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

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

</tbody>


Excel tables to the web >> Excel Jeanie HTML 4

For ease of explanation if i put ean code on report if there is no match

it shall indicate no match

in case ean code matches shall extract as sample on below

However I would prefer a range for EAN and extract the data

Summary

*D

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:99px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]349[/TD]
[TD="align: center"]ean[/TD]

[TD="bgcolor: #cacaca, align: center"]350[/TD]
[TD="align: right"]3121040031643[/TD]

[TD="bgcolor: #cacaca, align: center"]351[/TD]
[TD="align: right"]3612301710532[/TD]

[TD="bgcolor: #cacaca, align: center"]352[/TD]
[TD="align: right"]3612301713946[/TD]

[TD="bgcolor: #cacaca, align: center"]353[/TD]
[TD="align: right"]3612301714042[/TD]

[TD="bgcolor: #cacaca, align: center"]354[/TD]
[TD="align: right"]3612301714127[/TD]

[TD="bgcolor: #cacaca, align: center"]355[/TD]
[TD="align: right"]3612301764665[/TD]

[TD="bgcolor: #cacaca, align: center"]356[/TD]
[TD="align: right"]3612301764672[/TD]

[TD="bgcolor: #cacaca, align: center"]357[/TD]
[TD="align: right"]3612301778709[/TD]

[TD="bgcolor: #cacaca, align: center"]358[/TD]
[TD="align: right"]3612301778839[/TD]

[TD="bgcolor: #cacaca, align: center"]359[/TD]
[TD="align: right"]3612301791883[/TD]

[TD="bgcolor: #cacaca, align: center"]360[/TD]
[TD="align: right"]3612301791937[/TD]

[TD="bgcolor: #cacaca, align: center"]361[/TD]
[TD="align: right"]3612301792019[/TD]

[TD="bgcolor: #cacaca, align: center"]362[/TD]
[TD="align: right"]3612301792088[/TD]

[TD="bgcolor: #cacaca, align: center"]363[/TD]
[TD="align: right"]3612301792118[/TD]

[TD="bgcolor: #cacaca, align: center"]364[/TD]
[TD="align: right"]3612301792149[/TD]

[TD="bgcolor: #cacaca, align: center"]365[/TD]
[TD="align: right"]3612301792217[/TD]

[TD="bgcolor: #cacaca, align: center"]366[/TD]
[TD="align: right"]3612301792286[/TD]

[TD="bgcolor: #cacaca, align: center"]367[/TD]
[TD="align: right"]3612301792439[/TD]

[TD="bgcolor: #cacaca, align: center"]368[/TD]
[TD="align: right"]3612301792477[/TD]

[TD="bgcolor: #cacaca, align: center"]369[/TD]
[TD="align: right"]3612301793122[/TD]

[TD="bgcolor: #cacaca, align: center"]370[/TD]
[TD="align: right"]3612301793290[/TD]

[TD="bgcolor: #cacaca, align: center"]371[/TD]
[TD="align: right"]3612301793368[/TD]

[TD="bgcolor: #cacaca, align: center"]372[/TD]
[TD="align: right"]3612301793436[/TD]

[TD="bgcolor: #cacaca, align: center"]373[/TD]
[TD="align: right"]3612301793443[/TD]

[TD="bgcolor: #cacaca, align: center"]374[/TD]
[TD="align: right"]3612301793450[/TD]

[TD="bgcolor: #cacaca, align: center"]375[/TD]
[TD="align: right"]3612301793467[/TD]

[TD="bgcolor: #cacaca, align: center"]376[/TD]
[TD="align: right"]3612301793474[/TD]

[TD="bgcolor: #cacaca, align: center"]377[/TD]
[TD="align: right"]3612301793481[/TD]

[TD="bgcolor: #cacaca, align: center"]378[/TD]
[TD="align: right"]3612301827605[/TD]

[TD="bgcolor: #cacaca, align: center"]379[/TD]
[TD="align: right"]3612301842769[/TD]

[TD="bgcolor: #cacaca, align: center"]380[/TD]
[TD="align: right"]3612301842813[/TD]

[TD="bgcolor: #cacaca, align: center"]381[/TD]
[TD="align: right"]3612301842929[/TD]

[TD="bgcolor: #cacaca, align: center"]382[/TD]
[TD="align: right"]3612301842936[/TD]

[TD="bgcolor: #cacaca, align: center"]383[/TD]
[TD="align: right"]3612301843049[/TD]

[TD="bgcolor: #cacaca, align: center"]384[/TD]
[TD="align: right"]3612301843056[/TD]

[TD="bgcolor: #cacaca, align: center"]385[/TD]
[TD="align: right"]3612301853062[/TD]

[TD="bgcolor: #cacaca, align: center"]386[/TD]
[TD="align: right"]3612301853079[/TD]

[TD="bgcolor: #cacaca, align: center"]387[/TD]
[TD="align: right"]3612301853277[/TD]

[TD="bgcolor: #cacaca, align: center"]388[/TD]
[TD="align: right"]3612301853284[/TD]

[TD="bgcolor: #cacaca, align: center"]389[/TD]
[TD="align: right"]3612301869339[/TD]

[TD="bgcolor: #cacaca, align: center"]390[/TD]
[TD="align: right"]3612301869384[/TD]

[TD="bgcolor: #cacaca, align: center"]391[/TD]
[TD="align: right"]3612301870472[/TD]

[TD="bgcolor: #cacaca, align: center"]392[/TD]
[TD="align: right"]3612301870533[/TD]

[TD="bgcolor: #cacaca, align: center"]393[/TD]
[TD="align: right"]3612301870564[/TD]

[TD="bgcolor: #cacaca, align: center"]394[/TD]
[TD="align: right"]3612301871783[/TD]

[TD="bgcolor: #cacaca, align: center"]395[/TD]
[TD="align: right"]3612301871899[/TD]

[TD="bgcolor: #cacaca, align: center"]396[/TD]
[TD="align: right"]3612301872070[/TD]

[TD="bgcolor: #cacaca, align: center"]397[/TD]
[TD="align: right"]3612301873855[/TD]

[TD="bgcolor: #cacaca, align: center"]398[/TD]
[TD="align: right"]3612301874838[/TD]

[TD="bgcolor: #cacaca, align: center"]399[/TD]
[TD="align: right"]3612301878140[/TD]

[TD="bgcolor: #cacaca, align: center"]400[/TD]
[TD="align: right"]3612301878430[/TD]

[TD="bgcolor: #cacaca, align: center"]401[/TD]
[TD="align: right"]3612301878690[/TD]

[TD="bgcolor: #cacaca, align: center"]402[/TD]
[TD="align: right"]3612301879703[/TD]

[TD="bgcolor: #cacaca, align: center"]403[/TD]
[TD="align: right"]3612301879734[/TD]

[TD="bgcolor: #cacaca, align: center"]404[/TD]
[TD="align: right"]3612301881409[/TD]

[TD="bgcolor: #cacaca, align: center"]405[/TD]
[TD="align: right"]3612301881416[/TD]

[TD="bgcolor: #cacaca, align: center"]406[/TD]
[TD="align: right"]3612301902920[/TD]

[TD="bgcolor: #cacaca, align: center"]407[/TD]
[TD="align: right"]3612301902944[/TD]

[TD="bgcolor: #cacaca, align: center"]408[/TD]
[TD="align: right"]3612301902951[/TD]

[TD="bgcolor: #cacaca, align: center"]409[/TD]
[TD="align: right"]3612301902982[/TD]

[TD="bgcolor: #cacaca, align: center"]410[/TD]
[TD="align: right"]3612301904511[/TD]

[TD="bgcolor: #cacaca, align: center"]411[/TD]
[TD="align: right"]3612301904566[/TD]

[TD="bgcolor: #cacaca, align: center"]412[/TD]
[TD="align: right"]3612301904672[/TD]

[TD="bgcolor: #cacaca, align: center"]413[/TD]
[TD="align: right"]3612301904702[/TD]

[TD="bgcolor: #cacaca, align: center"]414[/TD]
[TD="align: right"]3612301904764[/TD]

[TD="bgcolor: #cacaca, align: center"]415[/TD]
[TD="align: right"]3612301904832[/TD]

[TD="bgcolor: #cacaca, align: center"]416[/TD]
[TD="align: right"]3612301904931[/TD]

[TD="bgcolor: #cacaca, align: center"]417[/TD]
[TD="align: right"]3612301905129[/TD]

[TD="bgcolor: #cacaca, align: center"]418[/TD]
[TD="align: right"]3612301906577[/TD]

[TD="bgcolor: #cacaca, align: center"]419[/TD]
[TD="align: right"]3612301923079[/TD]

[TD="bgcolor: #cacaca, align: center"]420[/TD]
[TD="align: right"]3612301940434[/TD]

[TD="bgcolor: #cacaca, align: center"]421[/TD]
[TD="align: right"]3612301950600[/TD]

[TD="bgcolor: #cacaca, align: center"]422[/TD]
[TD="align: right"]3612301950754[/TD]

[TD="bgcolor: #cacaca, align: center"]423[/TD]
[TD="align: right"]3612301950891[/TD]

[TD="bgcolor: #cacaca, align: center"]424[/TD]
[TD="align: right"]3612301950907[/TD]

[TD="bgcolor: #cacaca, align: center"]425[/TD]
[TD="align: right"]3612301951065[/TD]

[TD="bgcolor: #cacaca, align: center"]426[/TD]
[TD="align: right"]3612301951157[/TD]

[TD="bgcolor: #cacaca, align: center"]427[/TD]
[TD="align: right"]3612301954912[/TD]

[TD="bgcolor: #cacaca, align: center"]428[/TD]
[TD="align: right"]3612301954981[/TD]

[TD="bgcolor: #cacaca, align: center"]429[/TD]
[TD="align: right"]3612301954998[/TD]

[TD="bgcolor: #cacaca, align: center"]430[/TD]
[TD="align: right"]3612301967400[/TD]

[TD="bgcolor: #cacaca, align: center"]431[/TD]
[TD="align: right"]3612301967981[/TD]

[TD="bgcolor: #cacaca, align: center"]432[/TD]
[TD="align: right"]3612301969060[/TD]

[TD="bgcolor: #cacaca, align: center"]433[/TD]
[TD="align: right"]3612301969718[/TD]

[TD="bgcolor: #cacaca, align: center"]434[/TD]
[TD="align: right"]3612301972893[/TD]

[TD="bgcolor: #cacaca, align: center"]435[/TD]
[TD="align: right"]3612301976242[/TD]

[TD="bgcolor: #cacaca, align: center"]436[/TD]
[TD="align: right"]3612301982991[/TD]

[TD="bgcolor: #cacaca, align: center"]437[/TD]
[TD="align: right"]3612301983110[/TD]

[TD="bgcolor: #cacaca, align: center"]438[/TD]
[TD="align: right"]3612301983196[/TD]

[TD="bgcolor: #cacaca, align: center"]439[/TD]
[TD="align: right"]3612301983202[/TD]

[TD="bgcolor: #cacaca, align: center"]440[/TD]
[TD="align: right"]3612301983684[/TD]

[TD="bgcolor: #cacaca, align: center"]441[/TD]
[TD="align: right"]3612301983691[/TD]

[TD="bgcolor: #cacaca, align: center"]442[/TD]
[TD="align: right"]3612301983783[/TD]

[TD="bgcolor: #cacaca, align: center"]443[/TD]
[TD="align: right"]3612301983820[/TD]

[TD="bgcolor: #cacaca, align: center"]444[/TD]
[TD="align: right"]3612301984148[/TD]

[TD="bgcolor: #cacaca, align: center"]445[/TD]
[TD="align: right"]3612301984155[/TD]

[TD="bgcolor: #cacaca, align: center"]446[/TD]
[TD="align: right"]3612301984254[/TD]

[TD="bgcolor: #cacaca, align: center"]447[/TD]
[TD="align: right"]3612301984261[/TD]

[TD="bgcolor: #cacaca, align: center"]448[/TD]
[TD="align: right"]3612301985299[/TD]

[TD="bgcolor: #cacaca, align: center"]449[/TD]
[TD="align: right"]3612301985305[/TD]

[TD="bgcolor: #cacaca, align: center"]450[/TD]
[TD="align: right"]3612301985374[/TD]

[TD="bgcolor: #cacaca, align: center"]451[/TD]
[TD="align: right"]3612301985381[/TD]

[TD="bgcolor: #cacaca, align: center"]452[/TD]
[TD="align: right"]3612301985756[/TD]

[TD="bgcolor: #cacaca, align: center"]453[/TD]
[TD="align: right"]3612301991450[/TD]

[TD="bgcolor: #cacaca, align: center"]454[/TD]
[TD="align: right"]3612301992402[/TD]

[TD="bgcolor: #cacaca, align: center"]455[/TD]
[TD="align: right"]3612301992419[/TD]

[TD="bgcolor: #cacaca, align: center"]456[/TD]
[TD="align: right"]3612301992686[/TD]

[TD="bgcolor: #cacaca, align: center"]457[/TD]
[TD="align: right"]3612301992693[/TD]

[TD="bgcolor: #cacaca, align: center"]458[/TD]
[TD="align: right"]3612301992716[/TD]

[TD="bgcolor: #cacaca, align: center"]459[/TD]
[TD="align: right"]3612301992723[/TD]

[TD="bgcolor: #cacaca, align: center"]460[/TD]
[TD="align: right"]3612301992914[/TD]

[TD="bgcolor: #cacaca, align: center"]461[/TD]
[TD="align: right"]3612301992921[/TD]

[TD="bgcolor: #cacaca, align: center"]462[/TD]
[TD="align: right"]3612301993171[/TD]

[TD="bgcolor: #cacaca, align: center"]463[/TD]
[TD="align: right"]3612301993188[/TD]

[TD="bgcolor: #cacaca, align: center"]464[/TD]
[TD="align: right"]3612301996059[/TD]

[TD="bgcolor: #cacaca, align: center"]465[/TD]
[TD="align: right"]3612302001523[/TD]

[TD="bgcolor: #cacaca, align: center"]466[/TD]
[TD="align: right"]3612302001646[/TD]

[TD="bgcolor: #cacaca, align: center"]467[/TD]
[TD="align: right"]3612302001653[/TD]

[TD="bgcolor: #cacaca, align: center"]468[/TD]
[TD="align: right"]3612302001714[/TD]

[TD="bgcolor: #cacaca, align: center"]469[/TD]
[TD="align: right"]3612302001783[/TD]

[TD="bgcolor: #cacaca, align: center"]470[/TD]
[TD="align: right"]3612302002674[/TD]

[TD="bgcolor: #cacaca, align: center"]471[/TD]
[TD="align: right"]3612302004531[/TD]

[TD="bgcolor: #cacaca, align: center"]472[/TD]
[TD="align: right"]3612302004654[/TD]

[TD="bgcolor: #cacaca, align: center"]473[/TD]
[TD="align: right"]3612302004678[/TD]

[TD="bgcolor: #cacaca, align: center"]474[/TD]
[TD="align: right"]3612302004739[/TD]

[TD="bgcolor: #cacaca, align: center"]475[/TD]
[TD="align: right"]3612302005576[/TD]

[TD="bgcolor: #cacaca, align: center"]476[/TD]
[TD="align: right"]3612302006566[/TD]

[TD="bgcolor: #cacaca, align: center"]477[/TD]
[TD="align: right"]3612302006573[/TD]

[TD="bgcolor: #cacaca, align: center"]478[/TD]
[TD="align: right"]3612302006580[/TD]

[TD="bgcolor: #cacaca, align: center"]479[/TD]
[TD="align: right"]3612302006887[/TD]

[TD="bgcolor: #cacaca, align: center"]480[/TD]
[TD="align: right"]3612302006894[/TD]

[TD="bgcolor: #cacaca, align: center"]481[/TD]
[TD="align: right"]3612302006900[/TD]

[TD="bgcolor: #cacaca, align: center"]482[/TD]
[TD="align: right"]3612302006917[/TD]

[TD="bgcolor: #cacaca, align: center"]483[/TD]
[TD="align: right"]3612302007310[/TD]

[TD="bgcolor: #cacaca, align: center"]484[/TD]
[TD="align: right"]3612302008157[/TD]

[TD="bgcolor: #cacaca, align: center"]485[/TD]
[TD="align: right"]3612302008454[/TD]

[TD="bgcolor: #cacaca, align: center"]486[/TD]
[TD="align: right"]3612302008577[/TD]

[TD="bgcolor: #cacaca, align: center"]487[/TD]
[TD="align: right"]3612302008638[/TD]

[TD="bgcolor: #cacaca, align: center"]488[/TD]
[TD="align: right"]3612302008690[/TD]

[TD="bgcolor: #cacaca, align: center"]489[/TD]
[TD="align: right"]3612302009703[/TD]

[TD="bgcolor: #cacaca, align: center"]490[/TD]
[TD="align: right"]3612302009710[/TD]

[TD="bgcolor: #cacaca, align: center"]491[/TD]
[TD="align: right"]3612302012222[/TD]

[TD="bgcolor: #cacaca, align: center"]492[/TD]
[TD="align: right"]3612302012239[/TD]

[TD="bgcolor: #cacaca, align: center"]493[/TD]
[TD="align: right"]3612302012321[/TD]

[TD="bgcolor: #cacaca, align: center"]494[/TD]
[TD="align: right"]3612302012574[/TD]

[TD="bgcolor: #cacaca, align: center"]495[/TD]
[TD="align: right"]3612302012581[/TD]

[TD="bgcolor: #cacaca, align: center"]496[/TD]
[TD="align: right"]3612302012673[/TD]

[TD="bgcolor: #cacaca, align: center"]497[/TD]
[TD="align: right"]3612302013038[/TD]

[TD="bgcolor: #cacaca, align: center"]498[/TD]
[TD="align: right"]3612302013182[/TD]

[TD="bgcolor: #cacaca, align: center"]499[/TD]
[TD="align: right"]3612302014448[/TD]

[TD="bgcolor: #cacaca, align: center"]500[/TD]
[TD="align: right"]3612302014455[/TD]

[TD="bgcolor: #cacaca, align: center"]501[/TD]
[TD="align: right"]3612302014752[/TD]

[TD="bgcolor: #cacaca, align: center"]502[/TD]
[TD="align: right"]3612302014875[/TD]

[TD="bgcolor: #cacaca, align: center"]503[/TD]
[TD="align: right"]3612302015148[/TD]

[TD="bgcolor: #cacaca, align: center"]504[/TD]
[TD="align: right"]3612302015155[/TD]

[TD="bgcolor: #cacaca, align: center"]505[/TD]
[TD="align: right"]3612302015162[/TD]

[TD="bgcolor: #cacaca, align: center"]506[/TD]
[TD="align: right"]3612302015728[/TD]

[TD="bgcolor: #cacaca, align: center"]507[/TD]
[TD="align: right"]3612302020654[/TD]

[TD="bgcolor: #cacaca, align: center"]508[/TD]
[TD="align: right"]3612302020739[/TD]

[TD="bgcolor: #cacaca, align: center"]509[/TD]
[TD="align: right"]3612302022061[/TD]

[TD="bgcolor: #cacaca, align: center"]510[/TD]
[TD="align: right"]3612302022078[/TD]

[TD="bgcolor: #cacaca, align: center"]511[/TD]
[TD="align: right"]3612302022344[/TD]

[TD="bgcolor: #cacaca, align: center"]512[/TD]
[TD="align: right"]3612302022351[/TD]

[TD="bgcolor: #cacaca, align: center"]513[/TD]
[TD="align: right"]3612302022528[/TD]

[TD="bgcolor: #cacaca, align: center"]514[/TD]
[TD="align: right"]3612302023167[/TD]

[TD="bgcolor: #cacaca, align: center"]515[/TD]
[TD="align: right"]3612302023877[/TD]

[TD="bgcolor: #cacaca, align: center"]516[/TD]
[TD="align: right"]3612302027660[/TD]

[TD="bgcolor: #cacaca, align: center"]517[/TD]
[TD="align: right"]3612302027677[/TD]

[TD="bgcolor: #cacaca, align: center"]518[/TD]
[TD="align: right"]3612302027738[/TD]

[TD="bgcolor: #cacaca, align: center"]519[/TD]
[TD="align: right"]3612302027851[/TD]

[TD="bgcolor: #cacaca, align: center"]520[/TD]
[TD="align: right"]3612302027912[/TD]

[TD="bgcolor: #cacaca, align: center"]521[/TD]
[TD="align: right"]3612302028001[/TD]

[TD="bgcolor: #cacaca, align: center"]522[/TD]
[TD="align: right"]3612302028070[/TD]

[TD="bgcolor: #cacaca, align: center"]523[/TD]
[TD="align: right"]3612302028506[/TD]

[TD="bgcolor: #cacaca, align: center"]524[/TD]
[TD="align: right"]3612302028742[/TD]

[TD="bgcolor: #cacaca, align: center"]525[/TD]
[TD="align: right"]3612302029039[/TD]

[TD="bgcolor: #cacaca, align: center"]526[/TD]
[TD="align: right"]3612302030646[/TD]

[TD="bgcolor: #cacaca, align: center"]527[/TD]
[TD="align: right"]3612302030738[/TD]

[TD="bgcolor: #cacaca, align: center"]528[/TD]
[TD="align: right"]3612302032756[/TD]

[TD="bgcolor: #cacaca, align: center"]529[/TD]
[TD="align: right"]3612302032763[/TD]

[TD="bgcolor: #cacaca, align: center"]530[/TD]
[TD="align: right"]3612302033029[/TD]

[TD="bgcolor: #cacaca, align: center"]531[/TD]
[TD="align: right"]3612302037027[/TD]

[TD="bgcolor: #cacaca, align: center"]532[/TD]
[TD="align: right"]3612302037607[/TD]

[TD="bgcolor: #cacaca, align: center"]533[/TD]
[TD="align: right"]3612302038123[/TD]

[TD="bgcolor: #cacaca, align: center"]534[/TD]
[TD="align: right"]3612302040034[/TD]

[TD="bgcolor: #cacaca, align: center"]535[/TD]
[TD="align: right"]3612302041079[/TD]

</tbody>


Excel tables to the web >> Excel Jeanie HTML 4
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You must log in or register to reply here.

Forum statistics

Threads
1,223,229
Messages
6,170,881
Members
452,364
Latest member
springate

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