Looking to populate the subject line to include the cell value. However, the cell value is dependent on where the comment is coming from. For example, if I'm writing a comment in Cell S4 and row 4 corresponds to Google (currently cell A4), I'd like the subject line to read "Comment for Google"

I'd like to take this one step further so if the comment is made in Cell S5 and row 5 corresponds to Amazon (in cell A5), the subject line will automatically populate to "Comment for Amazon"

Currently have all the company names in column A and all the comments for a specific company will be made in the same row. Thanks in advance.

Please Login or Register  to view this content.