I'm a fairly advanced excel user but I have no VBA background and have only created macros using the macro recorder.
I would like to create a macro that searches column J for any cells that contain the text "TRAVEL" and then deletes the entire row(s) where "TRAVEL" was found to be in column J.
I am thinking that this is probably quite simple but I haven't been able to figure it out on my own.
Thanks,
Kelly
I would like to create a macro that searches column J for any cells that contain the text "TRAVEL" and then deletes the entire row(s) where "TRAVEL" was found to be in column J.
I am thinking that this is probably quite simple but I haven't been able to figure it out on my own.
Thanks,
Kelly