Help Linking Cell Formatting
 

Hello,

hoping someone can help me with a formatting issue.

In a nutshell, if I have a chart in date order, which I copy and paste, then
re-sort in alpha order, is it possible to link the two charts so that any
subsequent changes (specifically, the fill color) made to one chart will
automatically make the same change to the corresponding cells in the new
chart?

I will be making several changes an hour and am hoping that I can avoid
having to repeat cut/paste/re-sort each time I change the original.

Thanks!

--