Filter Out By Criteria

Rachit · Jun 7th 2007

I have a excel of about 5000 rows and 80 columns. Each row corresponds to a particular set of experiment. I want to reduce the number of rows by removing useless experimnets like controls etc. I want to search the row for some key words(ex. control) and if it present then remove it. It should prompt user to enter the keyword and the original file should not be disturbed. It can be copied to 2nd worksheet. Is such a code possible??

**royUK** · Jun 7th 2007

Re: Filtering By Name

You must post to the corrct Forum, no a Forum clearly marked No Question!

Anonymous · Jun 7th 2007

Re: Filtering By Name

Where is it jindon?

Anonymous · Jun 7th 2007

Re: Filtering By Name

Can you provide a link, please, jindon?

Rachit · Jun 7th 2007

Re: Filtering By Name

Hey, Please answer my question.

jindon · Jun 7th 2007

Re: Filtering By Name

Quote from ByTheCringe2

Can you provide a link, please, jindon?

Nope.

I can't even copy/paste, due to security setting here, sorry.

Anonymous · Jun 7th 2007

Re: Filtering By Name

Accepted the rules; thread re-opened.

Dave Hawley · Jun 7th 2007

Re: Filtering By Name

Use AdvancedFilter or AutoFilter

Rachit · Jun 7th 2007

Re: Filtering By Name

It is not able to do what i want. I want to copy filtered sheet in new worksheet without any tags hanging from top.

Dave Hawley · Jun 7th 2007

Re: Filtering By Name

No idea what "tags hanging from the top" means, but you simply Copy a filtered table and only non-filtered cells are copied/pasted.

Filter Out By Criteria

Participate now!

Share