I'm looking for a formula (I think a formula, or some other way) whereby I
enter data in one cell on one worksheet and it simultaneously (or after a
keystroke or two) fills in the same data in a cell that I select on another
worksheet, all within the same workbook. E.g., I type in the name "Roger" in
cell C3 on sheet 1. I would have previously set up a condition in a formula
or some other way whereby anything I type in cell C3 of sheet 1 is repeated
in cell D4 of sheet 2. In other words, Excel does the "copying" on-the-fly
using my pre-determined cells, i.e., anything I type in C3 is automatically
filled in D4 of another sheet I specify.
--
Tom