Original post was on 12/31/07 by EJR with a response from Ken Hudson. I need
to expand the original in that there is a potential that there could be up to
four records for a loan. To expand the original question, how could I edit
your macro so that if there is a 3rd record the info would go to cells H-I-J
and if there is a 4th record the info would go the cells K-L-M?

Thanks in advance for any help, EJR