Copy rows to another sheet if the row contains a certain value

[ghostexcel]

Hi all,

I am using this code:

Please Login or Register  to view this content.

The code works very fine when value in column J is exact match. I would the macro to do the same also when a non exact text is found, for example copy all rows to Sheet6 if the value in column J in Sheet5 contains "A Cat B", or "bla bla Cat B bla bla" and not only the exact match which is "Cat B".

When copying the rows to Sheet6 also the macro copy rows to the same row as it was in Sheet5, would it be possible to have the rows copied without any space between them in Sheet6.

Many thanks for all your help.

[Richard Buttrey]

Unfortunately your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)