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
R10 ITEM ADD, VENDOR CHANGE, ACTIVATE
R13 CONTRACT CHANGE
R15 PACKING CHANGE
I am having trouble writing the code to do this in VB. Any help would be appreciated.