I have a workbook with 3 sheets. Sheet 1 is the design and dimensions where
the information is gathered. Sheet 2 is a complete material list with blank
quantities. Sheet 3 is lists based lengths and widths that will be gathered
on Sheet 1.

Here is an example of one of the lists on Sheet 3.
Length Quantity
11 24
12 27
13 29
14 31
15 33
16 35
17 38
18 40
19 42
20 44

So on Sheet 1 the Length is entered into a text box. What I need to be able
to do is take the Length, say 16, entered into that text box on sheet 1, have
it reference this list on sheet 3 and correspond 16 to 35, and then take the
35 and enter it into a certain spot on sheet 2.

Any help would be appreciated.

Chris


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200510/1