how can I print from a search

[ezetobebad]

for example ,say i want to collate cells with 'hotels'. to do this i go to find & type in my search criteria. the problem is that the FIND box will not allow me to print the collated FIND results .Anyone there to help me please?

 

[Iridium]

Don't know how your s/s is set up but would a filter have the same effect (Data>Filter>Autofilter)? If you filter out for 'hotel' then only the rows containing that word are displayed and then you should be able to print the filtered list.

HTH