I have a spreadsheet with 2 tabs - one containing all the data, and another
that acts as a front end.

I have added several drop downs, and created macros that apply autofilters
to the data tab based on the selections.

I did want to add a keyword search box - is it possible either to create a
simple macro that summons the search box (ctrl - F) and pre-fills with the
keyword entered into a cell, or more spectacularly to then only summon the
whole records of anything containing that keyword?

All of my 'records' are on a row each on the data tab, so if there was a
match it woul just bring through the whole row for any containing the keyword?


Thanks for the help.


Paul