Without a macro, you can't. Why can't Sheet2!D6 accommodate a formula?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Ken Rock wrote:

Hi,
If I have data in Sheet1, cell A3 and I want it to appear in Sheet2 cell
D6, I can put a formula in Sheet2,D6 - something like =Sheet1!A3.
How can I send the data to Sheet2,D6 without having a formula in D6?
Thanks in advance.

Regards, Ken Rock