Excel transfer of comments

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