Hi, I have comments in most cells in columns F thru P. If the comment contains "[Current]", "[Past]" and/or "[Upcoming]", I want those element(s) to be copied to cell in column D of the same row only if that cell is empty. You may also include a command line to add the elements to the end of cell data even if the cell is not empty so I can have a better grasp of VBA. Cells in column D will contain only text.

Some comments may only contain one element, some may contain all three while some others may not have any of the elements present. Length of the region will keep growing (at present about 300) and used.range is perhaps the better way (sorry for my two cents!!).

I have come across many threads that copied entire comment to a cell, but not just selected elements. Thank you very much in advance.