Hi there
I have an excel spreadsheet containing many quotations said by famous people. These quotations are all in column A, taking up thousands of rows.
I want to create a macro that will find all the cells that contain a particular keyword of my choice (e.g. "happiness") and then put an "x" in column b adjacent to all the cells that contain that keyword.
Thanks very much for you assistance with this.
Cheers,
Graeme
I have an excel spreadsheet containing many quotations said by famous people. These quotations are all in column A, taking up thousands of rows.
I want to create a macro that will find all the cells that contain a particular keyword of my choice (e.g. "happiness") and then put an "x" in column b adjacent to all the cells that contain that keyword.
Thanks very much for you assistance with this.
Cheers,
Graeme