Thread
:
Can a formula place a value in another cell
View Single Post
#
6
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Can a formula place a value in another cell
As I said, a worksheet change event. Right click the sheet tabview
code
If all else fails
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"default105" wrote in message
...
Since my workbook is formula driven based on one cell on one worksheet and
the value I need to change resides on another worksheet, what event would
be
better to use. This one cell changes the data on 12 worksheets.
--
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
"Don Guillett" wrote:
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett