I have tried to right code to find the text containing "Consignment" on Col D
Once found, I need the data in the following columns in the same row as "consignment" to be cleared (have highlighted the cells to be cleared in yellow)
These are Col's G, K, H & U
it would be appreciated if someone could assist me
My code is
Please Login or Register to view this content.
Bookmarks