I have a matrix of information on sheet3. I want to loop: search column E for the integer 5 not .5, then return text from the corresponding row of column U into Sheet1, starting with cell A10. After that I then would like to copy formulas from range(B5:Y5) and have the same effect of pulling down copying. Help is very much appreciated. Thank in advanced for you time.