Mirroring entries from one sheet to another

Giganews Newsgroups
Subject: Mirroring entries from one sheet to another
Posted by:  Mr.Ribit (tben…@alliance.csc.com)
Date: 1 Oct 2003

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

Replies