search in excel 2000 (9.0.2720)
 

We have a filing system which has the file name in col A, and keywords in col
B. For example "Aa taxis" in A1, then "transport, travel, cars" in column B1.
Then"Best travel company" in A2, then "Transport, travel, taxis" in B2.
Then "Bonapart Restaurant" in A3, then "entertaining, eating" in B3.
I want to key in "Taxi" then have excel retrieve A1,A2,B1 & B2 & any other
cells which contain the word "Taxi".
Please bear in mind that I am not very technical, so for answers to be of
any help they need to be "Idiot proof".
(Did I just call myself an idiot?)
Thanks for any help....David Roper

search in excel 2000 (9.0.2720)
 

You can return the entire "rows" if any cell in a specific column contains
the word "taxi" by just using the Autofilter, Custom, and choosing the
"contains" selection.

Vaya con Dios,
Chuck, CABGx3



"droper" wrote:

We have a filing system which has the file name in col A, and keywords in col
B. For example "Aa taxis" in A1, then "transport, travel, cars" in column B1.
Then"Best travel company" in A2, then "Transport, travel, taxis" in B2.
Then "Bonapart Restaurant" in A3, then "entertaining, eating" in B3.
I want to key in "Taxi" then have excel retrieve A1,A2,B1 & B2 & any other
cells which contain the word "Taxi".
Please bear in mind that I am not very technical, so for answers to be of
any help they need to be "Idiot proof".
(Did I just call myself an idiot?)
Thanks for any help....David Roper