How can I enter text in one cell and have it copy to another cell
automatically, not using copy/paste feature. Such as type in date in cell A3
and it automatically appears in cell E33. Also, can this same feature work
if I use a data validation list and want that same pull down feature
selection to appear in another cell as well. Excel 2003.