I have two columns of data on sheet1 and I want to push rows of data (if they match my search parameters) to sheet 2.
Sheet 1
x a
y b
z c
x d
x e
y f
If I was searching on column 1 for instances of 'x' Sheet 2 should look like:
x a
x d
x e
Thanks for your help!
Bookmarks