Hello Ex(cel)perts. Im working on a macro that looks at column headers to perform some actions on the corresponding cells. I'm almost done with the VBA except for one thing that's making me bang my head on walls, I want to look at the cell to check if it's length is less than 8 and substitute from another cell if true. Both the cells are in same row but order of columns may change in every sheet/book, that is why I look for a column using its header.
My code so far looks like this:
Please pardon me if my code is inconsistent, I'm an amatuer. The code may look incomplete, because i have picked a part of the code that is relevant, macro is working fine without errors.
Please look at the section that reads "Creates Priority Date column"(3rd from the end) I need help there.
sample.PNG
In above sample,
1. For row 2, I want PRD column to retain its value (because it not empty)
2. For row 3, I want PRD column should get value from PRD1
I hope I have supplied sufficient information, please ask if you need to know more.
EDIT:
Asked same question @mr.excel.
Bookmarks