Copy worksheet to Userform

Akashwani

Akashwani

Well-known Member
Joined
Mar 14, 2009
Messages
2,911
Good day,

I hope that I am not asking too much with this one.

I have a workbook with 3 worksheets, 2 containing data and 1 used as a search and display sheet. I enter information into a cell, press enter and the relevant data is displayed in various cells.

I would like to create a userform to do the job of the search/display sheet, this is mainly to make it look more professional!

What do I need to add to the userform? Textboxes, Labels, Command Buttons etc, etc.

How would I go about transferring/copying the following data into a userform?

Thanks

Ak

<TABLE style="WIDTH: 1357pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1802><COLGROUP><COL style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 548" width=30><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 1024" width=56><COL style="WIDTH: 282pt; mso-width-source: userset; mso-width-alt: 6875" width=376><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 987" width=54><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 1865" span=5 width=102><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 1938" width=106><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 1865" span=2 width=102><COL style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 1974" width=108><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 2011" width=110><COL style="WIDTH: 144pt; mso-width-source: userset; mso-width-alt: 3510" width=192><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 1024" width=56><TBODY><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 23pt; HEIGHT: 11.25pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=15 width=30>A1</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 42pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=56>B1</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 282pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl205 width=376>C1</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 41pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=54>D1</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 77pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=102>E1</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 77pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=102></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 77pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=102></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 77pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=102></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 77pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=102></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 80pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=106></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 77pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=102></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 77pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=102></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 81pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=108></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 83pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=110></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 144pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl149 width=192></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 42pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=56>P1</TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 18.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=25></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl151></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl144>=TODAY()</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl153></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl154>=NOW()</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl155></TD></TR><TR style="HEIGHT: 24pt; mso-height-source: userset" height=32><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 24pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=32>A3</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl157>=COUNT(Master!A4:A301)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl160>Enter Product code below</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl187>P</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>N</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>M</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>E</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>F</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>S</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>W</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>S</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>S</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>G</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl189>R</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22>A5</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl193></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl197>=VLOOKUP(C5,Master,7,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,8,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,9,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,10,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,11,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,12,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,13,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,14,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,15,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,16,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl199>=VLOOKUP(C5,Master,17,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl161></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl190>B</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>M</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>O</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>M</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>C</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>M</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>G</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>H</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>L</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>S</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl192>P</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21>A7</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl162>Product details</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl200>=VLOOKUP(C5,Master,18,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,19,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,20,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,21,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,22,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,23,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,24,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,25,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,26,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,27,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl202>=VLOOKUP(C5,Master,28,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl163>Des</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl164></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21>A9</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; FONT-FAMILY: Calibri; BACKGROUND: #ffc7ce; COLOR: #9c0006; FONT-SIZE: 12pt; BORDER-TOP: #c0c0c0; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl165>=IF(ISNA(VLOOKUP(C5,Master,2,FALSE)),"Incorrect Product code",VLOOKUP(C5,Master,2,FALSE))</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl166>=VLOOKUP(C5,Master,29,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,30,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,31,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,32,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,33,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,34,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,35,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,36,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,37,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl168>=VLOOKUP(C5,Master,38,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl195>AL</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl164></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl170>=VLOOKUP(C5,Master,39,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,40,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,41,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,42,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,43,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,44,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,45,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,46,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,47,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl172>=VLOOKUP(C5,Master,48,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21>A11</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl173>=VLOOKUP(C5,Master,3,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl164></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl170>=VLOOKUP(C5,Master,49,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,50,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,51,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,52,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,53,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,54,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,55,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,56,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,57,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl172>=VLOOKUP(C5,Master,58,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl169>Wa</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl164></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl170>=VLOOKUP(C5,Master,59,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,60,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,61,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,62,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,63,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,64,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,65,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,66,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,67,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl172>=VLOOKUP(C5,Master,68,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21>A13</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl173>=VLOOKUP(C5,Master,4,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl164></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl170>=VLOOKUP(C5,Master,69,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,70,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,71,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,72,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,73,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,74,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,75,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,76,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,77,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl172>=VLOOKUP(C5,Master,78,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl169>Ar</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl164></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl170>=VLOOKUP(C5,Master,79,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,80,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,81,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,82,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,83,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,84,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,85,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,86,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,87,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl172>=VLOOKUP(C5,Master,88,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22>A15</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl174>=VLOOKUP(C5,Master,5,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl164></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl175>=VLOOKUP(C5,Master,89,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176>=VLOOKUP(C5,Master,90,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176>=VLOOKUP(C5,Master,91,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176>=VLOOKUP(C5,Master,92,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176>=VLOOKUP(C5,Master,93,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176>=VLOOKUP(C5,Master,94,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176>=VLOOKUP(C5,Master,95,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl177></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=20></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl178></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22>A17</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl196>=COUNTA(Ingredients!A4:A200)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl203></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl179>=COUNTIF(Master!C4:C302,"Yes")</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl180>Enter Part code below</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl145>=(C19)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl146>Comprises</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl147></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl147></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl148></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl181></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22>A19</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl194></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,3,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,4,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,5,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,6,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,7,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl181></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl181></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl182>Des</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,8,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,9,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,10,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,11,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,12,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl181></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl181></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21>A21</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; FONT-FAMILY: Calibri; BACKGROUND: #ffc7ce; COLOR: #9c0006; FONT-SIZE: 11pt; BORDER-TOP: #c0c0c0; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl183>=IF(ISNA(VLOOKUP(C19,ing,2,FALSE)),"Incorrect Part code",VLOOKUP(C19,ing,2,FALSE))</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,13,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,14,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,15,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,16,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,17,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl184></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl204></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl186></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=20>A23</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142>E23</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142>P23</TD></TR></TBODY></TABLE>
 
Sort by date Sort by votes
If you want the userform to call your search/display routine you need a text box to enter the search criteria and a button to start the search.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
To display the data after the search you can do it two different ways.
<o:p></o:p>
1. Add labels and text boxes for each piece of data you want to display using the following code<o:p></o:p>
Code: 
[COLOR=black][COLOR=black]Textbox1 = sheet1.range(“A1”)[/COLOR]
[COLOR=black]<o:p>[COLOR=black]Textbox2 = sheet1.range(“A2”)[/COLOR]</o:p>[/COLOR]
[COLOR=black]<o:p></o:p>[/COLOR]
[COLOR=black]'[/COLOR]
[COLOR=black]<o:p></o:p>[/COLOR]
[COLOR=black]'[/COLOR]
[COLOR=black]'[/COLOR]
[/COLOR]


2. Add a Spredsheet control to the userform and use the following code to populate the spread sheet<o:p></o:p>
Code: 
[COLOR=black][COLOR=black]Dim MyRange As String<o:p></o:p>[/COLOR]
[COLOR=black]MyRange = Sheets(1).UsedRange.Address<o:p></o:p>[/COLOR]
[COLOR=black]Me.Spreadsheet1.ActiveSheet.Range(MyRange) = Sheets(1).UsedRange.Value[/COLOR]
[/COLOR]
<o:p></o:p>
You can hide the column and row labels, the scroll bars, etc. so only the cells are displayed.<o:p></o:p>
<o:p></o:p>
Hope this helps
 
Upvote 0
Hi Bill,
Thanks for the reply.
Unfortunately I don't quiet crasp the advice you have offered :(
I have created all the Text boxes, labels and 2 buttons.
My User form now looks a bit like my "search" sheet, :)
I now have 2 questions (for starters, no doubt!)..

1, What code would I need for the "search" button?
2, Do I need a code for the text box where I would type in the "Product code" on the user form?

Ak
 
Upvote 0
What code would I need for the "search" button?
Click to expand...
The code would consist of whatever you are searching for. Most likely in a find statement. The code would be in the Search Button procedure. Need detail as to what you are searching for<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

Do I need a code for the text box where I would type in the "Product code" on the user form?
Click to expand...
 <o:p></o:p>
You would only enter the searched for data in the textbox. The search routine would access that data, then do the search.
 
Upvote 0
Hi Bill,

I will be searching for a "Product code" numerical, once found, this will then reference 70+ pieces of data that I would like displayed.

I hope that helps a little!

Ak
 
Upvote 0
I created a sample sheet with Product numbers in column A and associated product data in column B. I dont know how your product table is set up.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
I created a useform with a commanbutton named cbSearch and three textboxes named:
tbLookFor user to enter product number to search for in this box.
tbDada1 code to populate this box.
tbData2 code to populate this box.
<o:p></o:p>
Place the following code in the tbSearch button code procedure
Code: 
Option Explicit<o:p></o:p>
 <o:p></o:p>
Private Sub cbSearch_Click()<o:p></o:p>
    Dim Product As Range<o:p></o:p>
 
    Set Product = Sheets("Sheet1").Range("A1:A50").Find(Val(tbLookFor), lookat:=xlWhole, LookIn:=xlValues)<o:p></o:p>
    If Product Is Nothing Then<o:p></o:p>
        MsgBox "Product not found"<o:p></o:p>
    Else<o:p></o:p>
        'Populate the userform with data<o:p></o:p>
        tbData1 = Product.Offset(1, 1)   'Down 1 row, over 1 column<o:p></o:p>
        tbData2 = Product.Offset(2, 1)    'Down  row, over 1 column<o:p></o:p>
        '<o:p></o:p>
        '<o:p></o:p>
        'and 68 more<o:p></o:p>
    End If<o:p></o:p>
[FONT=Times New Roman]End Sub[/FONT]

Enter the product to be searched into the tbLookFor text box and click the tbSearch button. The data fields will be populated.

Hope this helps
 
Upvote 0
Hiya Bill,

Thank you very much, your code does exactly what I need.

I just need to do add a few more lines!

No doubt I will be back on here at some point with a further query, but I am confident that someone will come to my rescue again. :)

Thanks Bill

Ak
 
Upvote 0
I have had success with this code for my first search button...
Code: 
Option Explicit
 
Private Sub cbSearch_Click()
    Dim Product As Range
 
    Set Product = Sheets("Master").Range("A1:A300").Find(Val(tbLookFor), lookat:=xlWhole, LookIn:=xlValues)
    If Product Is Nothing Then
        MsgBox "Product not found"
    Else
        'Populate the userform with data
        tbData1 = Product.Offset(0, 1)   'Down 1 row, over 1 column
        tbData2 = Product.Offset(0, 2)
        tbData3 = Product.Offset(0, 3)
        tbData4 = Product.Offset(0, 4)
        ' etc, etc
    End If
End Sub

However, when I modified it for the second search button with this code, it does not return any data, it just says "Product not found"....

Code: 
Private Sub cbSearch2_Click()
    Dim Part As Range
 
    Set Part = Sheets("Ingredients").Range("A1:A100").Find(Val(tbLookFor2), lookat:=xlWhole, LookIn:=xlValues)
    If Part Is Nothing Then
        MsgBox "Product not found"
    Else
        'Populate the userform with data 
        tbData97 = Part.Offset(0, 1)   'Down 1 row, over 1 column
        tbData98 = Part.Offset(0, 2)
        tbData99 = Part.Offset(0, 3)
        tbData100 = Part.Offset(0, 4)
        tbData101 = Part.Offset(0, 6)
        ' etc, etc
    End If
End Sub

Any ideas on where I have gone wrong?

Ak
 
Upvote 0
Run this program and then look at you r worksheet to see if the range was selected. Is your part number your looking for in this range?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
Code: 
Sub SelectRange()<o:p></o:p>
    Sheets("Ingredients").Range("A1:A100").Select
End Sub
Is the part number entered on the spreadsheet as alpha?
Copy the part number of the spreadsheet and paste it into the find statement replacing Val(tbLookFor2). Run the program and enter any part number. If your hard coded part number is found then you have a mismatch as to what is entered in the textbox and what is in the parts list.<o:p></o:p>
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
947
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
3K
Attrazion
A
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
E
  • Question Question
VBA for Web Scraping help
Replies
0
Views
1K
epactheactor
E
E
  • Question Question
Query in excel to Outlook mail take rows with name until next name
Replies
0
Views
549
esben
E

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