Copying row to another worksheet

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?

By: Donna

Leave a Reply

Your email address will not be published. Required fields are marked *