search and display macro

[bencpv]

hi, I wonder if someone could help me out.....i have a spreadsheet drawing log and i want to create a search function that searches each line and displays any rows containing the search criteria.

Attached is the spreadsheet. My hope is that the user is to enter some keyword(s) in the search box at the top, click 'SEARCH', and bingo - rows containing the criteria are displayed. E.g if 'ohmic' is searched for, rows 9 and 10 are shown.

Any help would be appreciated.

Thanks in advance

[mahaveersomani]

where is the attached file?

[bencpv]

oops, sorry.....

[mahaveersomani]

do you want to search text from "column F" only?

[bencpv]

do you want to search text from "column F" only?

I would likeit to search column A and F if thats possible? - i could just use the filters for the other columns.
thanks