Hi,
I would like to search a column for blank cell. if a blank cell is found, to concatenate "info required" and text in the previous column
ColA ColB ColC
Joy yes hey
Peace oh
Hope hmm ok
code to search col C, find the blank cell and insert 'info required Peace'
Thank you
I would like to search a column for blank cell. if a blank cell is found, to concatenate "info required" and text in the previous column
ColA ColB ColC
Joy yes hey
Peace oh
Hope hmm ok
code to search col C, find the blank cell and insert 'info required Peace'
Thank you