I have a situation where I need to analyze a range (F9:Q100) and if the cell contents are > 0 insert the header into another field . (See attached picture) Example: Referencing the attached picture, I would like column R to have the following text:
R8 PACKAGING CHANGE, CONTRACT CHANGE, UOM CHANGE
R9
R10 ITEM ADD, VENDOR CHANGE, ACTIVATE
R11
R12
R13 CONTRACT CHANGE
R14
R15 PACKING CHANGE
R16
Sample.png
I am having trouble writing the code to do this in VB. Any help would be appreciated.
Thanks,
Met
Bookmarks