Create a column upon insertion or overwriting of data.

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

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


---
Regards,
Norman


"Swiatkowski Peter" <[email protected]> wrote in message
news:[email protected]...
> 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
>