how can i use the = to move formatting and content between tabs?

[Need Excel help!]

I am trying to use the = sign to bring the exact content from cells in
another tab to another tab (data, colors, formatting, formulas, etc).

is this possible?

 

[Alan]

It will give you only the value in the cell, it won't tell you the formula
(if any) or transfer the formatting.
Regards,
Alan.

 

[Gord Dibben]

Not possible with a simple linking of cells.

Linking brings content only.


Gord Dibben MS Excel MVP