Can a comment only in a cell on one sheet be transferred to a cell on another sheet in the same workbook? The code looks up a customer address. The comment will be in the customer's
name cell associated with this record. I need to do it in a cell formula.