Update linked worksheets

R

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.
 
F

Frank Kabel

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

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.
 
R

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
 
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
 
Top