This did the trick. I didn't have to enter the macro . I used the same
formula on all cells. Thanks so much.

"ghighigirl" wrote:

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.