automatically change Format and comments in linked sheets/cells

[howard]

on sheet1, I have all my data. I have several sheets where I have linked the data for each branch, using Paste Special Paste Link All when copying the data


However, I if change a comment or fill color on sheet1, this does not change on the linked sheet.



your assistance in this regard is most appreciated

 

[Fluff]

Also covered here https://www.mrexcel.com/forum/excel-questions/1059904-copy-range-names-applicable-sheet.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).