Posted to microsoft.public.excel.programming
|
|
inputbox help
Have you looked at built in capabilities that can do this such as Autofilter
and Advanced filter under the Data menu or creating a Pivot Table report
under the data menu as well.
--
Regards,
Tom Ogilvy
lothario wrote in message
...
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 you
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
|