Create a column upon insertion or overwriting of data.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Swiatkowski Peter - 20 Dec 2005 11:22 GMT

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

Reply to this Message

Norman Jones - 20 Dec 2005 11:43 GMT

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

> Hello,
>
[quoted text clipped - 4 lines]
>
> Peter

Reply to this Message