Hi,
I have several thousand files where I need to delete rows containing a specific word in a specific column, e.g. if the cell contains the word forecast in column C.
I also need to check if cells in another column contains a number, period and space before a word and if so remove the number, period and space but leave the word, and not delete the row.
Please can someone help me with a macro to do this automatically without needing me to manually open each file.
Thanks
I have several thousand files where I need to delete rows containing a specific word in a specific column, e.g. if the cell contains the word forecast in column C.
I also need to check if cells in another column contains a number, period and space before a word and if so remove the number, period and space but leave the word, and not delete the row.
Please can someone help me with a macro to do this automatically without needing me to manually open each file.
Thanks