How do I get formatting to transfer to worksheets that have a cell link.
For example -
I have a mastersheet where I make all my corrections and then I have sub sheets with links to the master. I can get the data to transfer fine by using the "paste link" option, but I can't figure out how to make the updated formatting (i.e. font color, strikethrough, etc.) I'm doing to the main worksheet transfer to the links in the other worksheets.
For example -
I have a mastersheet where I make all my corrections and then I have sub sheets with links to the master. I can get the data to transfer fine by using the "paste link" option, but I can't figure out how to make the updated formatting (i.e. font color, strikethrough, etc.) I'm doing to the main worksheet transfer to the links in the other worksheets.