Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
string values do not equal cells, then return msg
I have a cell with "A,AA,AAA" minus the quotes. On another sheet I have
4 cells, each labeled, "A", "AA", "AAA", "AAAA" The "A,AA,AAA" will be pulled apart using a split command as as string, and compared to the 4 cells on the other sheet, If any part of the now split string does not match any of the values in the 4 cells, then return a msg. So if on the first cell I had "A,AA,AAB" , "AAB" does not match any of the 4 cell values on the 2nd sheet and will return an error. If all of the now split cell values having a matching cell on the 2nd sheet, then do nothing. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Matching cells across columns, and returning equal values | Excel Discussion (Misc queries) | |||
Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
Formula to find equal values with blank cells | Excel Discussion (Misc queries) | |||
lineup equal values by inserting empty cells | Excel Discussion (Misc queries) | |||
SOS VBA Code Emergency: need to copy tell to empty cell direct below where values in adjacent cells in different column are equal to each other. | Excel Programming |