Hello,
I have a large excel database with over 20,000 rows as in the attached example and would like a VBA macro script which pops up a search form like the binoculars tab to search a between 1 to 10 words (text or values) within the database on sheet 1. Whenever any word is found, the whole row is copied onto sheet 2. I require the search to be effected on the entire sheet 1, and not within a single column. I would also need the search not to be an exact 'match' i.e. i'd like it to pick words within words - e.g. if I search for 'car' in the form and there exists a word named 'cards' on the database (sheet 1), then i'd like it to copy the 'cards' row onto sheet 2 as well. On the attached file I have shown an example of how the search for the words: Car, Toner, Cartridge and Ink would result on sheet 2.
I thank you for your support and assistance
Bookmarks