Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I want to run an operation, but, this may have already been done, so i need to notify user of that and not run again. Specifically: I need to search the 'Entry Log' sheet (columns A and B) for the word 'Enzyme' in column A, and a specific six digit number in column B (the number is already defined as variable req1). These two entries must be found adjascent to each other, in order for the find/match to be true. Example: req1 is currently 123456 So, in order for my macro to continue, I want to search the sheet 'Entry Log' for the word 'Enzyme' in column A and 123456 in column B (adjascent). If it does not find, the macro continues. If it does find that match, say in range A26:B26, then a message to user appears that data has already been entered, etc... and then exits. Note: The Entry Log sheet Column A will have either the word Enzyme, or Strip, or Error. Column B will have many different six digit numbers. Thanks for any assistance, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Check multiple cells for a match | Excel Discussion (Misc queries) | |||
I need to check for a number in a column before continuing on | Excel Programming | |||
Check Cell Content before continuing... | Excel Programming | |||
check value with array, Application.Match | Excel Programming | |||
Check columns for data match... | Excel Programming |