Entering data on one worksheet in a certain column and automatically appearing on another worksheet

Posted by Chris Jones on May 22, 2001 5:30 AM

Any help here would be greatly appreciated.

I need to figure out how if possible, that I could get data that as it is being entered on one worksheet appears on another worksheet. I don't want it to be exactly mirrorred. For example, if I enter data in C6 on the one sheet, I want it to show up on D9 of the other worksheet.

If you don't understand the question, just notify me and I will try to clarify.

Posted by Anon on May 22, 2001 5:39 AM

Clue :-
If on the same sheet you wanted to make B1 always be equal to A1, what would you do? Would you select B1, type = , select A1, and then press enter?

Posted by Al Polan on May 22, 2001 5:17 PM

If I understand you correctly, all you have to do is click on D9 in the one worksheet and put the = sign in it, then go to your other worksheet and click on cell C6 it will have a moving line around it, just hit enter and everything you put in C6 will be automatically entered into D9 on the other worksheet.