Hi all,
I am using this code:
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.
Bookmarks