A
AF_INstructor
I need help with VBA code. I need the code to look down a range (suc
as J12:L48) and find the data (i.e. "D", "M8A", "CR1", etc) and retur
the associated name on the same row to it's left (the I column). I
then needs to copy that name into the C, E, and G column. C column i
associated with J column; E is associated with K, and G with L. Ther
will be multiple (up to 20) results that meet the criteria, so, it wil
have do a loop until it finds all or fills all available cells. I hav
been able work simple formula for when it matches one criterion bu
can't seem to find a solution for multiple criteria. Would appreciat
any help to get me going - if you have any questions or would like
copy of this "schedule" please let me know.
Mar
as J12:L48) and find the data (i.e. "D", "M8A", "CR1", etc) and retur
the associated name on the same row to it's left (the I column). I
then needs to copy that name into the C, E, and G column. C column i
associated with J column; E is associated with K, and G with L. Ther
will be multiple (up to 20) results that meet the criteria, so, it wil
have do a loop until it finds all or fills all available cells. I hav
been able work simple formula for when it matches one criterion bu
can't seem to find a solution for multiple criteria. Would appreciat
any help to get me going - if you have any questions or would like
copy of this "schedule" please let me know.
Mar