I have a "souce sheet" with two columns, one has a "name", the other a
I will have all the names in a list
So I will loop through the list, get each name in turn, then find the
matching name row on the Source sheet and get the associated number - enter
where needed on target sheet
I don't know an easier way than looping through the whole source sheet name
each time looking for a match to the "target name"
The names will probably be in the same order in my target list as in the
source sheet column
but it seems better programming not to rely on that being true necessarily.
If they were guaranteed to match I could use an index number and just
increment that for the
next row to check, but is there a more direct way?
Kind of like an sql statement something like(pseudocode) Get colB Where
colA.Value = TargetName
without having to repeatedly loop through the entire list each time?
(hope that was clear)