i have a column of data, both text and numbers and would like to be able to
search for specific words in each cell and separate them onto there own
page.
example. "159 x 496 green door" "159 x 596 blue door" "720 x 396 green door"
i would like to put all the green doors on there own page. all the blue on
another ect.ect.
the text is not always in the same order. i.e. "door 159 x 496 blue fascia"
"720 x 590 red front" ect ect

please be patient as i am relatively new to excel.

thanks for your help.
Phil