Hello All,
Please find the attached sample where I would like VBA to search for an Array of Text in Col L from L3 till down.
Note that there may be blanks in Col L.
eg Type1, Type2, Type3, Type5, Type6, Type7 and fill up "PC" on the same Row under Col O where one of the Types are found.
Note that there may already values under Col O or blanks.
Col O should replace the old values or blank Ozgrid Help.xlsxOzgrid Help.xlsxwith "PC"
Thanks in advance