I know that you can have entered text appear in another worksheet using CTRL
and clicking the tab for that worksheet, but can you have text you enter
appear automatically in a specifed cell on another worksheet? Using Excel
2000.