| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting Linked Cells | Excel Discussion (Misc queries) | |||
| linking cells to carry forward a hyperlink | Setting up and Configuration of Excel | |||
| How can I carry cell formatting in paste link | Excel Discussion (Misc queries) | |||
| Is there a way to carry formatting to a different sheet? | Excel Discussion (Misc queries) | |||
| Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
