Macro to copy worksheet data to another worksheet based on criteria

Hi everyone !

Can someody help me create a macro that will search data from a range of cells based on one criteria and copy the entire data to a new worksheet ?

Example I have a list of Channel Names :

Cartoon Network
Disney Channel
CNN
BBC

I want all the Data of CNN to be copied on another worksheet named CNN. The worksheet should be created with a macro.

Here is my code :

Please Login or Register  to view this content.

Thanks in advance !