| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching for 3 variables
I would like to loop thru sheet; GI columns A, I & K row 1.
Search sheet RJE for matches, (GI column A= RJE= column C) 5 chars beginning with a 6 (GI column I= RJE= column H). (GI column K= RJE=column A). For a match to be considered correct, all 3 cells, row 1, from GI must match the same row in RJE.IF yes, colour the row green in RJE. Go back to GE and begin again at row 2, etc. Before I begin trying to code this, could the search be done in a multi-dimensional array, and if so how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching | Excel Discussion (Misc queries) | |||
| Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
| Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
| Searching for variables in excel database | Excel Discussion (Misc queries) | |||
| Searching | Excel Programming | |||
Linear Mode
