A formula may not do that but you can use =a1 to get the data in a1.
However, you may use a worksheet_change event macro in the sheet module that
when a1 is changed will do whatever is desired to the other cell.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"default105" wrote in message
...
with excel 2000, can a formula place a value in another cell or can this
only
be done with vba or a macro
--
Pete Blackburn - words to live by:
"Don''t ever let somebody tell you. You can''t do something.You got a
dream,You gotta protect it." Edited Quote from the Pursuit Of Happiness