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

--
Message posted from http://www.ExcelForum.com

Curious about the significance of I with J, K, L.

Go on, send me the schedule. You need to remove the junkmail part from my
e-mail.

Rob


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

Mark


---
Message posted from http://www.ExcelForum.com/