Update linked worksheets

[re1murphy]

I have a workbook with 2 worksheets. The worksheets have same data in
one column. What is best way to link the worksheets so that when I
insert a row in worksheet1, a row is inserted at the same location in
worksheet2?

Thanks in advance.

 

[Frank Kabel]

Hi
you can't linkn formulas this way. This would IMHO require VBA (an
event procedure)

 

[RagDyer]

Group the sheets together.
Hold <Ctrl> and click in the tab of the second sheet, so that *both* tabs
are white.

Now, anything you do to one, will be duplicated in the other.

Don't forget to "ungroup" when you're done.
Right click in a tab, and choose "UngroupSheets".
--

HTH,

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

I have a workbook with 2 worksheets. The worksheets have same data in
one column. What is best way to link the worksheets so that when I
insert a row in worksheet1, a row is inserted at the same location in
worksheet2?

Thanks in advance.

 

[re1murphy]

RagDyer,

Thanks for the info. That method works very well if the columns I a
linking are in the same column on both worksheets. Unfortunately, th
data that I am trying to keep in sync is in a different column an
starts in a different row in worksheet2. I'm trying to insure tha
when I insert a row for a new entity in worksheet1, a corresponding ro
is inserted in worksheet2. Any ideas on this?

Thanks
R

 

[RagDyer]

Just as Frank said ... code !
--


Regards,

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

RagDyer,

Thanks for the info. That method works very well if the columns I am
linking are in the same column on both worksheets. Unfortunately, the
data that I am trying to keep in sync is in a different column and
starts in a different row in worksheet2. I'm trying to insure that
when I insert a row for a new entity in worksheet1, a corresponding row
is inserted in worksheet2. Any ideas on this?

Thanks
RM