Linked worksheets

[rachnacyprus]

Hi,
I am trying to copy and paste cells in the same workbook as linked cells but on pasting the format of the cells changes, e.g. blamk cells have a zero in them or a default date in case of a blank date cell.

Please help

Rachna

 

[dsgs]

if you only do this once, again copy the cells and paste special --> format

 

[rachnacyprus]

sorry, does not work