Mirroring entries from one sheet to another

  • Thread starter Thread starter Mr.Ribit
  • Start date Start date
M

Mr.Ribit

Is there a way to mirror what happens to the entries in columnA of
sheet1 to columnA on sheet2
I've been able to get the value over to sheet2 with no problem and if
I change it then that change is also reflected on sheet2
What I can't do is to insert a new row on sheet1 and have that
insertion reflected in sheet2.
I am using Excel 2000 SP1 on a Windows 2000 workstation.

Thanks
 
One downside of doing it this way is that the inserted rows on Sheet1 will
no longer "mirror" the new data entered on Sheet2.
You must now fill the inserted rows in Sheet1 with the "duplicating"
formula.

One possible option is to combine linking with Indirect.
Enter this in Sheet1, starting in A1:

=INDIRECT("Sheet2!A1")
=INDIRECT("Sheet2!A2")
=INDIRECT("Sheet2!A3")
.... etc.
If you have to do this for a great many cells in Column A, enter this in A1
and copy down:

=INDIRECT("Sheet2!A"&ROW())

This formula will allow you to insert rows on Sheet2 and will then "mirror"
on Sheet1 any data you enter into the inserted rows on Sheet2.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Liz
Your grouping suggestion works like a charm, I love simple solutions.
Are there any downsides? I am adding macros and formulas to do a
number of things. Can I expect a downside?

Thanks Again
Thomas
 
Back
Top