Triggering excel fields

[Ken]

I'm running Excel 2000. I have created a spreadsheet that
I would like to "trigger" a field to be populated when
another field on that same line is used. One of the
problems I find is that I have multiple spreadsheets, each
with a different amount to be triggered. Each sheet has
the same amount though.

Any help would be appreciated.

 

[Dave Peterson]

I'd use a helper cell that was formatted Red, bold and with arrows pointing at
the cell that needs to be filled in:

=if(a1="","","<=== Please fill this in!")

When A1 is empty, you don't see the message. As soon as you put something in
A1, you get that irritating message.

 

[Wim Ruepert]

I am afraid your question is a bit confusing. Perhaps you can give an
example.

Wim

 

[David McRitchie]

Hi Ken,
I think what you want is an Event macro, take a look at
http://www.mvps.org/dmcritchie/excel/excel.htm
If that doesn't help post with a more specific question.