VBA to clear contents of the cell in a column of data in a cell starts with specific word.
Have to clear the contents of all those cells in a coloumn which starts from "Property ID"
Have attached the excel file where data and needed result is mentioned.
Bookmarks