I am wanting to know how to do two things please:
1) I have a worksheet with lots of rows. I want to filter those down so that if Column G says certain words, eg Confirmed or Complete, that whole row is automatically copied to Sheet 2.
2) Also, I want to have a search function so that if i type in “Pink” for example, it will list everything that says pink in columns, E & F but no other columns.
They are very similar requests, I know. Can anyone help?