Linking to include Comments

  • Hello,


    If you are looking for a solution without VBA ...


    You can use Paste As Picture > Paste Picture Link which will work for formatting ...BUT NOT for the Comments ...


    If you need both ... you will have to use a macro ...


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Many thanks


    SO I have found many vba codes online that output comments into cells from the master workbook to my workbook. The comments can then be used with conditional formatting for my purpose. All good so far.


    But when I log back in to a PC and open both work books the output comments show '#value' and do not work. I have to re-link to the source data each time.


    Is this to be expected?

  • Hello,


    Have you checked the Edit Links and checked Automatic for the Update ... :wink:


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!