Excel transfer of comments

Closed
j4lidas
Posts
1
Registration date
Thursday January 22, 2015
Status
Member
Last seen
January 22, 2015
- Jan 22, 2015 at 10:08 AM
from excel file to excel file, how can I get comments updated automatically, similar to vlookup or hlookup?

i.e. comment in cell c4 of file abc.xlsx to cell c4 of file xyz.xlsx. Don't want to use copy paste as there are many comments from multiple files to consolidate into 1.

Thanks J4lidas