Copying data from 1 worksheet to another w/out spaces

[Andrew Hardscape]

Hello Folks,

Here is another one of my pain in the backside ideas. I hope I am explaining this clearly

I have particular 2 sheets that are part of the same worbook.

One sheet is titled 'Cost Sheet'

The 'Cost Sheet' is used for calculating construction job materials, costs, etc.

The second sheet is titled 'Material List'

The 'Material List' copies data from the cost sheet when a "1" is placed in the rows of COLUMN B on the 'Cost Sheet'.

If you look at the 'Material List' sheet, you will see row spaces between the items. Is there a way that anyone can share as to how to have the 'Material List" sheet copy the info from the 'Cost Sheet' and fill in the rows without the spaces?


COST SHEET:

Paver Cost Ver IV.xls
	B	C	D	E
15		Filter Cloth	2990	$ 0.14
16		Concrete Sand	7	$ 30.00
17		Joint Sand	5	$ 7.23
18		Spikes 10" Galvanized	224	$ 0.50
19	1	SNAP Edge Restraint	28	$ 9.78
20	1	Polymeric Joint Sand	0	$ 22.95
21		DC Rects	224.00	$ -
22	1	DC Rects	120.00	$ -
23			0.00	$ -
24			0.00	$ -
25			0.00	$ -
26			0.00	$ -
27			0	$ -
28			0	$ -
29			0	$ -
30			0	$ -
31			0	$ -
32			0	$ -
33			0	$ -
34			0	$ -
35			0	$ -
36			0	$ -
37			0	$ -
38		ADDTL CR8	0	$ 14.00
39	1	135 mm Celtik Wall		$ 12.40
40		90 mm Celtik Wall		$ 12.40
41	1	Cel Cap Module		$ 7.90
42	1	Adhesive	5	$ 5.95
43		Filter Cloth		$ 0.14
44		Gravel, 3/4"		$ 14.00
Cost Sheet

MATERIAL LIST<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=5><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - Paver Cost Ver IV.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: xl2002 XP : OS = Windows XP</FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=5><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD vAlign=center align=right><FORM name=formCb658016><INPUT onclick='window.clipboardData.setData("Text",document.formFb431795.sltNb305190.value);' type=button value="Copy Formula" name=btCb074442></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=5><TABLE border=0><TBODY><TR><FORM name=formFb431795><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value" name=sltNb305190><OPTION value="=IF('Cost Sheet'!B15=1,'Cost Sheet'!C15,"")" selected>A15<OPTION value="=IF('Cost Sheet'!B15=1,'Cost Sheet'!D15,"")">B15<OPTION value="=IF('Cost Sheet'!B16=1,'Cost Sheet'!C16,"")">A16<OPTION value="=IF('Cost Sheet'!B16=1,'Cost Sheet'!D16,"")">B16<OPTION value="=IF('Cost Sheet'!B17=1,'Cost Sheet'!C17,"")">A17<OPTION value="=IF('Cost Sheet'!B17=1,'Cost Sheet'!D17,"")">B17<OPTION value="=IF('Cost Sheet'!B18=1,'Cost Sheet'!C18,"")">A18<OPTION value="=IF('Cost Sheet'!B18=1,'Cost Sheet'!D18,"")">B18<OPTION value="=IF('Cost Sheet'!B19=1,'Cost Sheet'!C19,"")">A19<OPTION value="=IF('Cost Sheet'!B19=1,'Cost Sheet'!D19,"")">B19<OPTION value="=IF('Cost Sheet'!B20=1,'Cost Sheet'!C20,"")">A20<OPTION value="=IF('Cost Sheet'!B20=1,'Cost Sheet'!D20,"")">B20<OPTION value="=IF('Cost Sheet'!B21=1,'Cost Sheet'!C21,"")">A21<OPTION value="=IF('Cost Sheet'!B21=1,'Cost Sheet'!D21,"")">B21<OPTION value="=IF('Cost Sheet'!B22=1,'Cost Sheet'!C22,"")">A22<OPTION value="=IF('Cost Sheet'!B22=1,'Cost Sheet'!D22,"")">B22<OPTION value="=IF('Cost Sheet'!B23=1,'Cost Sheet'!C23,"")">A23<OPTION value="=IF('Cost Sheet'!B23=1,'Cost Sheet'!D23,"")">B23<OPTION value="=IF('Cost Sheet'!B24=1,'Cost Sheet'!C24,"")">A24<OPTION value="=IF('Cost Sheet'!B24=1,'Cost Sheet'!D24,"")">B24<OPTION value="=IF('Cost Sheet'!B25=1,'Cost Sheet'!C25,"")">A25<OPTION value="=IF('Cost Sheet'!B25=1,'Cost Sheet'!D25,"")">B25<OPTION value="=IF('Cost Sheet'!B26=1,'Cost Sheet'!C26,"")">A26<OPTION value="=IF('Cost Sheet'!B26=1,'Cost Sheet'!D26,"")">B26<OPTION value="=IF('Cost Sheet'!B27=1,'Cost Sheet'!C27,"")">A27<OPTION value="=IF('Cost Sheet'!B27=1,'Cost Sheet'!D27,"")">B27<OPTION value="=IF('Cost Sheet'!B28=1,'Cost Sheet'!C28,"")">A28<OPTION value="=IF('Cost Sheet'!B28=1,'Cost Sheet'!D28,"")">B28<OPTION value="=IF('Cost Sheet'!B29=1,'Cost Sheet'!C29,"")">A29<OPTION value="=IF('Cost Sheet'!B29=1,'Cost Sheet'!D29,"")">B29<OPTION value="=IF('Cost Sheet'!B30=1,'Cost Sheet'!C30,"")">A30<OPTION value="=IF('Cost Sheet'!B30=1,'Cost Sheet'!D30,"")">B30<OPTION value="=IF('Cost Sheet'!B31=1,'Cost Sheet'!C31,"")">A31<OPTION value="=IF('Cost Sheet'!B31=1,'Cost Sheet'!D31,"")">B31<OPTION value="=IF('Cost Sheet'!B32=1,'Cost Sheet'!C32,"")">A32<OPTION value="=IF('Cost Sheet'!B32=1,'Cost Sheet'!D32,"")">B32<OPTION value="=IF('Cost Sheet'!B33=1,'Cost Sheet'!C33,"")">A33<OPTION value="=IF('Cost Sheet'!B33=1,'Cost Sheet'!D33,"")">B33<OPTION value="=IF('Cost Sheet'!B34=1,'Cost Sheet'!C34,"")">A34<OPTION value="=IF('Cost Sheet'!B34=1,'Cost Sheet'!D34,"")">B34<OPTION value="=IF('Cost Sheet'!B35=1,'Cost Sheet'!C35,"")">A35<OPTION value="=IF('Cost Sheet'!B35=1,'Cost Sheet'!D35,"")">B35<OPTION value="=IF('Cost Sheet'!B36=1,'Cost Sheet'!C36,"")">A36<OPTION value="=IF('Cost Sheet'!B36=1,'Cost Sheet'!D36,"")">B36<OPTION value="=IF('Cost Sheet'!B37=1,'Cost Sheet'!C37,"")">A37<OPTION value="=IF('Cost Sheet'!B37=1,'Cost Sheet'!D37,"")">B37<OPTION value="=IF('Cost Sheet'!B38=1,'Cost Sheet'!C38,"")">A38<OPTION value="=IF('Cost Sheet'!B38=1,'Cost Sheet'!D38,"")">B38<OPTION value="=IF('Cost Sheet'!B39=1,'Cost Sheet'!C39,"")">A39<OPTION value="=IF('Cost Sheet'!B39=1,'Cost Sheet'!D39,"")">B39<OPTION value="=IF('Cost Sheet'!B40=1,'Cost Sheet'!C40,"")">A40<OPTION value="=IF('Cost Sheet'!B40=1,'Cost Sheet'!D40,"")">B40<OPTION value="=IF('Cost Sheet'!B41=1,'Cost Sheet'!C41,"")">A41<OPTION value="=IF('Cost Sheet'!B41=1,'Cost Sheet'!D41,"")">B41<OPTION value="=IF('Cost Sheet'!B42=1,'Cost Sheet'!C42,"")">A42<OPTION value="=IF('Cost Sheet'!B42=1,'Cost Sheet'!D42,"")">B42<OPTION value="=IF('Cost Sheet'!B43=1,'Cost Sheet'!C43,"")">A43<OPTION value="=IF('Cost Sheet'!B43=1,'Cost Sheet'!D43,"")">B43<OPTION value="=IF('Cost Sheet'!B44=1,'Cost Sheet'!C44,"")">A44<OPTION value="=IF('Cost Sheet'!B44=1,'Cost Sheet'!D44,"")">B44</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value="=IF('Cost Sheet'!B15=1,'Cost Sheet'!C15,"")" name=txbFb428726></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>A</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>B</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>C</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>D</CENTER></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>15</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[0].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb431795.sltNb305190.options[1].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" colSpan=2></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>16</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[2].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb431795.sltNb305190.options[3].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" colSpan=2></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>17</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[4].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb431795.sltNb305190.options[5].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" colSpan=2></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>18</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[6].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb431795.sltNb305190.options[7].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" colSpan=2></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>19</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">SNAP Edge Restraint</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">28.00</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" colSpan=2></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>20</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">Polymeric Joint Sand</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">0.00</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" colSpan=2></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>21</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[12].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb431795.sltNb305190.options[13].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" colSpan=2></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>22</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">DC Rects</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">120.00</FONT></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" colSpan=2></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>23</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[16].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb431795.sltNb305190.options[17].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" colSpan=2></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>24</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[18].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb431795.sltNb305190.options[19].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" colSpan=2></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>25</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[20].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb431795.sltNb305190.options[21].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" colSpan=2></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>26</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[22].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb431795.sltNb305190.options[23].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" colSpan=2></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>27</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[24].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb431795.sltNb305190.options[25].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" colSpan=2></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>28</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[26].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb431795.sltNb305190.options[27].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center" colSpan=2></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>29</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[28].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"></FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 12pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><A onclick="document.formFb431795.sltNb305190.options[29].selected=true; document.formFb431795.txbFb428

 

[joelnichols]

Autofilter the Material sheet, using 'non blank' could work for you.

 

[IJQ]

Hi,

Why not try to make a Form with a list and be able to select the required items and insert in the appropriate cells.

IJQ

 

[Andrew Hardscape]

Joel -

Thanks, however I tried the auto filter using non blank and for some reason it did not work. I may have done something wrong. Its rows 14-44 that I want filtered.

Might you have any advice, or step by step instructions? I'm only 40% XL literate!

Thanks