Hello,

I have a master schedule on one tab and want to copy each individuals schedule onto separate tabs. I don't want to have to copy the information again if I make changes to the master so I put ="Master"Cell# to copy the information over. Unfortunately, the color that the cells are highlighted on the master, did not copy over. Can anyone help me get both the text and the color copied, without using copy/paste?

Thanks in advance for the help!

Nicole