Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
notify of entered criteria
I have list of criteria E104, E105, E107, E123, E124, E127, E131, E142,
E952, E1510, ALCOHOL The criteria is listed in "A1" How do I get my spreadsheet to notify me if any of the above criteria is entered into any other part of the spreadsheet? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
notify of entered criteria
On Sep 5, 4:37 am, Ken wrote:
I have list of criteria E104, E105, E107, E123, E124, E127, E131, E142, E952, E1510, ALCOHOL The criteria is listed in "A1" How do I get my spreadsheet to notify me if any of the above criteria is entered into any other part of the spreadsheet? Would the entry be a cell with nothing but one of those criteria in it? Because then COUNTIF could work. Although you'd want to move each criterion to its own cell for ease of use. Could be done on a separate sheet. Otherwise probably a macro to search would be best. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
notify of entered criteria
Never used Macro search before. Would this automatically notify me of the
entry or would I have run the search eachtime? "Spiky" wrote: On Sep 5, 4:37 am, Ken wrote: I have list of criteria E104, E105, E107, E123, E124, E127, E131, E142, E952, E1510, ALCOHOL The criteria is listed in "A1" How do I get my spreadsheet to notify me if any of the above criteria is entered into any other part of the spreadsheet? Would the entry be a cell with nothing but one of those criteria in it? Because then COUNTIF could work. Although you'd want to move each criterion to its own cell for ease of use. Could be done on a separate sheet. Otherwise probably a macro to search would be best. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Notify Message? | Excel Discussion (Misc queries) | |||
I need a chart reference if certain criteria is entered... | Excel Discussion (Misc queries) | |||
Notify | Excel Discussion (Misc queries) | |||
Can excell notify me of due dates? | New Users to Excel | |||
Can Excel notify me when a date is due? | Excel Discussion (Misc queries) |