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.
|