I want to type in a text string in worksheet 1 and have Excel search for that text string within certain ranges on worksheet 2, then copy all cells containing (not exactly matching) that text string to worksheet 1.
For example, I type in ABC in cell A1 of worksheet 1 - Excel then looks at all cells in Column BB and BD in worksheet 2, then copies all cells containing ABC in worksheet 1
Solved by S. Y. in 16 mins