how to make this range in this case ?

[vumian]

hi everyone,

i have 1 range in sheet1 that contains many item, i fill and font color
any for per cell

i wanna copy all of them to other sheet2, but if i changed any in range
in sheet1, then range in sheet changed too. it mean they are a mirror

How to do it ?

thanks in advance.

 

[Óã¸É]

EDIT-SELECTION PASTE-DATA

sorry,Perhaps like this.My system isn't english.

 

[vumian]

hi Óã¸É
sorry, i fail to understand your mean

i mean i wanna create a mirror range

thank you hor help

 

[Bob Umlas]

Copy, Paste special/Paste Link button
Bob Umlas
Excel MVP

 

[David McRitchie]

one more point, the colors of the copied to sheet will
not change automatically . If that is important you would
need to use conditional formatting on both sheets,
or run a subroutine regularly (or possibly just before printing),
or create/use an Event macro.

 

[vumian]

hi,

thanks for advice
there are some problem following:

1) if i do it like Bob Umlas said, the all of format it not copied
2) if i insert row or col in sheet1, but sheet2 is not inserted, no
same the sheet 1 anymore

How to sovle this problem , help me please

thanks in advance

 

[David McRitchie]

If you can put all of the data on one sheet then you might
save yourself a lot of problems. A macro could be used
to create separate sheets for presentation based on the
original

There is nothing automatic to insert rows in another worksheet
when another worksheet inserts rows. There is not even a
generated Event that could trigger an Event Macro.

When you paste formats you are copying what is present
when you copy and paste, they are not dynamic. Changing
the color on a row is not going to change the color on the
copy.