I have the following data on sheet1
<colgroup><col width="52" style="width: 39pt; mso-width-source: userset; mso-width-alt: 1901;">
<col width="54" style="width: 41pt; mso-width-source: userset; mso-width-alt: 1974;">
<col width="95" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3474;">
<col width="44" style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609;">
<col width="55" style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;">
<col width="52" style="width: 39pt; mso-width-source: userset; mso-width-alt: 1901;">
<col width="44" style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609;">
<col width="61" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;">
<col width="49" style="width: 37pt; mso-width-source: userset; mso-width-alt: 1792;">
<col width="27" style="width: 20pt; mso-width-source: userset; mso-width-alt: 987;">
<col width="37" style="width: 28pt; mso-width-source: userset; mso-width-alt: 1353;">
<col width="32" style="width: 24pt; mso-width-source: userset; mso-width-alt: 1170;">
<tbody>
</tbody>
Can a drop box on sheet 2 specifying tile size pull data or without drop box , I know the normal filter is the best option but trying to spoon feed the sales team since some are weak users, they would hardly know how to use the FILTER option
COLOUR | ART NO. | BRAND | SIZE | SURFACE | PACKING | M2 CTN | OUR CODE | INC | STK | BOOK | FREE |
Grey | GCM04 | CEMENTUM | 60 X 60 | Matt | 3 | 1.08 | 239.000.02 | 2,450.00 | 0 | ||
White | GCM01 | CEMENTUM | 60 X 60 | Matt | 3 | 1.08 | 239.000.01 | 2,450.00 | 0 | ||
Crema | GGS12 | GRANTITE STONE | 30 X 60 | Rock | 8 | 1.44 | 239.000.03 | 3,505.00 | 0 | ||
Crema | GGS12 | GRANTITE STONE | 30 X 60 | Rock | 3 | 1.08 | 239.000.78 | 2,590.00 | 0 |
Can a drop box on sheet 2 specifying tile size pull data or without drop box , I know the normal filter is the best option but trying to spoon feed the sales team since some are weak users, they would hardly know how to use the FILTER option