Moving comments to another workbook via formula.

Is it possible to move comments from a cell into another workbook using a formula.

I have an aging report with comments and would like to move them to a newer version using a vlookup but I haven't been able to find a way.

Any ideas?

Hi andresndor,

cell comments cannot be captured by formulas, only text/values within cells. You would have to use VBA or so, or copy/cut the specific cells to the new workbook.

Cheers,
berlan