Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Popups to look up on two variable columns
Hi I have a small project that I hope someone can help with. I need a popup to request the choice of a column , and then select all cells which have contain a number below an input number. Then a popup would request the choice of a second column , and ask for specific content. It would select all rows below the number input in the first popup which matched the content entered in the second. For example ; The first popup(s) input specifies all cells numbered below 100 in column B. The second popup(s) would specify a certain content - Say 'Blue' - in column F. Result : 1 Green - Not Selected 2 Blue - Selected 23 Blue - Selected 44 Yellow - Not Selected 56 Blue - Selected 78 Red - Not Selected 102 Blue - Not Selected 203 Blue - Not Selected 205 Green - Not Selected 204 Yellow - Not Selected Grateful for any advice. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Popups to look up on two variable columns
Send file with explanation to dguillett1 @gmail.com Should be easy enough. On Thursday, March 15, 2012 11:33:48 AM UTC-5, Colin Hayes wrote: Then a popup would request the choice of a second column , and ask for specific content. It would select all rows below the number input in the first popup which matched the content entered in the second. For example ; The first popup(s) input specifies all cells numbered below 100 in column B. The second popup(s) would specify a certain content - Say 'Blue' - in column F. Result : 1 Green - Not Selected 2 Blue - Selected 23 Blue - Selected 44 Yellow - Not Selected 56 Blue - Selected 78 Red - Not Selected 102 Blue - Not Selected 203 Blue - Not Selected 205 Green - Not Selected 204 Yellow - Not Selected Grateful for any advice. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA to sidestep popups... | Excel Worksheet Functions | |||
Using Popups to supply variables | Excel Worksheet Functions | |||
Automated Popups | Excel Worksheet Functions | |||
Using popups instead of Message Box | Excel Programming | |||
Date PopUps | Excel Programming |