I have two identical sheets. If something is entered into a cell in sheet1, how do I get excel to automatically enter the same value into an identical cell in sheet2 and do this on a cell by cell basis not as a copy of a range of cells? Any help is greatly appreciated.