Copying and Referencing data and formatting

[Guest]

Greetings.

I have a a column of data in one worksheet which I wish to appear in several
other worksheets in my spreadsheet - complete with formatting.

The problem is the source data changes all the time. Therefore, at the
moment, I am simply re-copying and pasting the data (and formatting)
everytime I make a change. Isn't there a way I can just reference this data
so it is duplicated each time? I have tried just using an "=x:y" formula, but
this does not copy formatting, so things like cell shading and hyperlinks are
being lost.

Any ideas?

Thanks,

Pies.

 

[Frank Kabel]

Hi
unfortunately no chance to 'link' formats.
Excel just does not provide this feature to update other cells then you
change your formts