Hi all,
I have a common problem a 500-1000 row report. The report comes to me as an Excel file with most of the important information in the "comment" field. I would like a solution to move the document file name into the cell to the right. The document file name always starts with "\\adm"
This field contains random notes, links to documents on our server.
I'd like to see how to create a nested if statement or other technique to use inside a macro.
I have attached a mock spreadsheet showing "How it is Now" and "How I want it to Be".
Thanks in advance for your comments,
Adam
Bookmarks