Carry over formatting between linked cells.
 

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?

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?

Carry over formatting between linked cells.
 

That's what I was afraid of. Do you know how to do it in VBA? I know NOTHING
about VBA programming.

"Sheeloo" wrote:

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?

Carry over formatting between linked cells.
 

To learn about macros visit
http://www.taltech.com/support/sw_tricks/exmacros.htm

The following code will copy the format from Sheet1 A1:K10
to the same cellls in Sheet2
Remove the line nos... there are just to avoid problems due to line wrap in
the post

1 Sub Macro1()
2 Sheets("Sheet1").Range("A1:K10").Copy
3 Sheets("Sheet2").Range("A1").PasteSpecial Paste:=xlPasteFormats,
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
4 End Sub

"WDS" wrote:

That's what I was afraid of. Do you know how to do it in VBA? I know NOTHING
about VBA programming.

"Sheeloo" wrote:

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?