Hi,

I have values in sheet1 as below:

TEST TEST1 TEST2 TEST3
A AAA EE II
B BBB FF TT
C CCC GG BB
D DDD HH EE
A EEE II QQ


I would like to return on sheet2 the rows that contain the value of "A" in column 1 (TEST column):

TEST TEST1 TEST2
A AAA EE
A EEE II


As you can see I dont want to return the whole row - ideally I would like to be able to choose the columns that I can copy over to sheet2. Thanks again for the help as always.