I thank royUK very much for the post I made with "Autofilter with color" but the trouble is that there is a large cell by each of the color cell about 4 rows wide with text (sorry royUK I did'nt have these large cells in the old attachment).
When I switched to Autofilter in ColumnD for the red ones, the large cells with texts became only 1 row wide which left some of the original text out.
Is there a vba code that can keep those large cells while search in autofilter?
I've enclosed an attachement to get an idea, thank you.
AutoFilterWithLargeCells.xls
Bookmarks