Hi,

Look at the attached screenshot.
Can you show me the inputbox code that:

a. Asks for a "Model" and a "Year".

b. Selects all the rows that contain that model. (Note: *contains*
the text)

c. And from those selected rows it further sub-selects rows where
the "Year" is greater than or equal to the "FROM Year" AND
the "Year" is less than or equal to the "To Year".

d. Finally, it copies this short list (entire rows) to the "results
sheet
starting at cell B3. The "results" sheet is in the same workbook.

So if you entered "ks" for the Model and "94" for the Year then yo
would get the result:

M3 , ks5 , 91 , 94 , 0 , , ALP1608 , 79.46 , ...
M3 , ks5 , 91 , 95 , 0 , , AF1632 , 199 , ...
M3 , ks5 , 91 , 95 , 0 , , AH1634 , 312.63 , ...
M3 , ks5 , 91 , 95 , 0 , , ALP1646 , 44.58 , ...
M3 , ks5 , 91 , 95 , 0 , , ALP1647 , 44.58 , ...


Thanks

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements