Linking a range of cells from one sheet to another and preserving the formatting

[ggeoff]

Hi

I have linked a range of cells on one worksheet in the same work book to another sheet in the same workbook but I have lost all the formatting. Is there a way to preserve the formatting? I am using Excel 2007 and conditional formatting.

 

[svendiamond]

The only way is to use VBA to copy and paste.

 

[ggeoff]

The only way is to use VBA to copy and paste.

Thanks. My other alternative is to print a selection and explain how to do that for any users who want to use part of the results.