linking cells between worksheets

D

Dawn101

When linking cells only the formula/value is copying over, I also need the
formatting. Is this possible?
 
R

RichardSchollar

Hi Dawn

Not really - formulas can't amend the formatting of the cell in which
they reside (other than in limited circumstances eg by Conditional
Formatting). You would need to copy and pastespecial the formats from
the target cells yourself, I'm afraid.

Best regards

Richard
 
P

Prasadkakarla

Hello Dawn

You can link the cell from one work book to another , One cell to antoher
cell, one sheet to another sheet,

you can get the linked data only, You can't get the original format
While linking the formula or anything. (For link) u will get the original
result except the original format
 
R

RagDyeR

On a case by case basis, you can do this in 2 steps.

Right click in the source cell and choose copy,
Navigate to the target sheet and right click in the target cell,
Choose Paste Special,
Click on Paste Link,
Right click again in the target cell,
Choose Paste Special,
Click on Formats,
Then <OK>.

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

When linking cells only the formula/value is copying over, I also need the
formatting. Is this possible?
 
Top