find several words/names in a column and cut and paste row to another workbook or page
Posted on 2014-10-13
I have a workbook that has a column with differing names and then in row an address - some are called andy jones, some are fred doe, some are julie smith etc. etc.
I need to run a macro to which I can add the "chosen christian name (s)" as there may be one or more I need to such as julie & john, and the macro then finds the fields that include the christian name, then cut and past that row which includes address into sheet 2 of the worksheet.
Can anyone help?