linking cells between worksheets
 

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

linking cells between worksheets
 

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


Dawn101 wrote:

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

linking cells between worksheets
 

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

--
Name : K.Prasad
Inventory Manager
CRYSTALGALLERY
DUBAI



"Dawn101" wrote:

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

linking cells between worksheets
 

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!
================================================== ===

"Dawn101" wrote in message
...
When linking cells only the formula/value is copying over, I also need the
formatting. Is this possible?