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.
This is a discussion on how can I print from a search within the Excel Questions forums, part of the Question Forums category; for example ,say i want to collate cells with 'hotels'. to do this i go to find & type in ...
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?