Carry over formatting between linked cells.

  • Thread starter Thread starter WDS
  • Start date Start date
W

WDS

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?
 
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...
 
That's what I was afraid of. Do you know how to do it in VBA? I know NOTHING
about VBA programming.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked spreadsheet is not automatically adjusting row height? 2
Color in Linked Worksheets 2
Excel Highlighting duplicates 0
Editing Data in Multiple Worksheets/Workbooks 1
I swapped my CPU, how do I carry over all my programs and settings? 1
Trace links between worksheets within one workbook 4
protect cell formatting 3
Linking cells in a Workbook - Formatting is lost 4

Back
Top