View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Carry over formatting between linked cells.

You can not unless both sheets have the same distribution of cells, then you
can paste the format over the linked cells after copying the original cells
(PASTE SPECIAL|Formats)

Othe option is through VBA...

"WDS" wrote:

I have a sheet in a workbook in which I have linked to other worksheets in
the same workbook. The original cells I have linked to have specific
formatting, but it doesn't carry over into the linked cell. How do I carry
over the formatting to the linked cell?