Create a column upon insertion or overwriting of data.

[Swiatkowski Peter]

Hello,

What should I read up on, where to look, what is the function or feature
called, to learn how Excel spreadsheet be configured so that upon insertion
or overwriting data in a cell, a new cell will be populated with the results
that display relative difference and a percentage of change ?

Peter

 

[Norman Jones]

Hi Peter,

You should look at the Worksheet_Change event.

If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

For information on event procedures see David McRitchie's Event procedures
page at:

http://www.mvps.org/dmcritchie/excel/event.htm

For an in depth discussion of Event procedures see Chip Pearson at:

http://www.cpearson.com/excel/events.htm