Thank you very much. I used the first one since there isn't much consistency in the worksheet. Can you only loop if there aren't consistent columns or is there a way around that? Thanks again.