Sorting using Macro

[prasjohn]

Hi all, I have a requirement to sort on each item, if that item text is present in a cell.Please see the attached file. 'Reference' sheet has names of fruits. Now if we go to 'Results' sheet, ' T 'column, it has many fruits names separated by semi-colon. If we filter using "contains", for fruit, say , apple, it will give four results. So, all these four results should be copied(entire row) to another worksheet(name= apple), including the title, as shown done manually in 'Apple' worksheet. Similarly it should happen for other fruits also. Can this be automated, perhaps by using a macro... ? I use 2003 version.

Any help will be highly appreciated ...

Thanks in advance !

[antoka05]

See attached file where I added this macro:

Please Login or Register  to view this content.

Regards,
Antonio

[prasjohn]

Thanks a ton Antonio !!!!!.. Just one more.. it is working for first 19 rows of reference list as per my attached sheet.. however, can you make this work for the all the rows in reference sheet ? It is not always restricted to 19 .... Thanks once again...

[antoka05]

The macro reads dynamically the number of rows in the Reference sheet, it's not fixed to 19 rows.
However tell me if you need I change something.

Regards,
Antonio

[prasjohn]

Hi Antonio, when I try to add more rows(upto 60, which is my actual requirement) it is returning an error(Error 400 ). I have attached the modified file for your reference; Thanks once again !!!

[prasjohn]

This got SOLVED.. thanks a lot to Antonio and all other...

[antoka05]

I checked my code and I've seen there were 2 times the same fruit name.
If you want I can modify the macro to skip double fruit name and avoid the error.

Regards,
Antonio