how to make this range in this case ?

EDIT-SELECTION PASTE-DATA

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

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

i mean i wanna create a mirror range

thank you hor help.

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

"vumian" <vumian.2cn2s3_1155742205.9543@excelforum-nospam.com> wrote in
message news:vumian.2cn2s3_1155742205.9543@excelforum-nospam.com...
>
> 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.
>
>
> --
> vumian
> ------------------------------------------------------------------------
> vumian's Profile:
http://www.excelforum.com/member.php...o&userid=36494
> View this thread: http://www.excelforum.com/showthread...hreadid=572235
>

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.

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, not same the sheet 1 anymore

How to sovle this problem , help me please

thanks in advance.

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"vumian" <vumian.2coq9r_1155819305.6462@excelforum-nospam.com> wrote in message
news:vumian.2coq9r_1155819305.6462@excelforum-nospam.com...
>
> 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, not
> same the sheet 1 anymore
>
> How to sovle this problem , help me please
>
> thanks in advance.
>
>
> --
> vumian
> ------------------------------------------------------------------------
> vumian's Profile: http://www.excelforum.com/member.php...o&userid=36494
> View this thread: http://www.excelforum.com/showthread...hreadid=572235
>