VBA code to return all values in column that match a specified value

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.

Please Login or Register  to view this content.

you can change A and D to the columns you need as appropriate, if it is not a continuous range of columns then probably be best to split it onto separate lines of code and move each column on its own line, for example:

Please Login or Register  to view this content.