I am trying to set up a template to make my month end processing easier. I want to automatically pull data from a Details worksheet that has an "I" in column E to a worksheet called Insurance, in the same workbook. I need to return all values into the corresponding colums A:P. The problem is, there are H's and P's intermixed with the I's. I'm not sure of the best way to approach this issue. Vlookup seems like it might work...but if E2<>I, I have no idea how to get it to evaluate the next record...

Thanks!
G