Folks,
Please help me to build a Macro to search text string "WorkPack Approval:" in Column A, then clear all contents from cell contains text string "WorkPack Approval:" to just above text string "Comments:". And add new cell value in the same cell as "LOG BOOK:"
I have attached the work book of what I am trying to accomplish.
Thanks in advance for your time and expertise
Bookmarks