Sheet #2 has information that I must transfer to sheet #1. The data that I want from Sheet #2 are from these columns/rows: A81:G1008 and if H81:H1139 says "Yes" I would like that data from Sheet #2 A81:G1008 to go over to sheet #1. I cannot use a macro. Can anyone help me? Thank you.