PC Review


Reply
Thread Tools Rate Thread

Create a column upon insertion or overwriting of data.

 
 
Swiatkowski Peter
Guest
Posts: n/a
 
      20th Dec 2005
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 With Quote
 
 
 
 
Norman Jones
Guest
Posts: n/a
 
      20th Dec 2005
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofill is overwriting the column title..... =?Utf-8?B?cmFwaGllbDIwNjM=?= Microsoft Excel Programming 4 6th Sep 2007 05:50 PM
Can I create a form with column headers based on the data for data editing? Stapes Microsoft Access 1 15th Jun 2007 05:30 PM
repeating data in column to empty cells below without overwriting =?Utf-8?B?amVmZmNoaW5h?= Microsoft Excel Worksheet Functions 1 26th Apr 2007 05:50 PM
create macro to move label type data to column data =?Utf-8?B?Sm9uYXRob25Xb29kOQ==?= Microsoft Excel Programming 4 21st Feb 2005 10:53 PM
Column E cell contents added into Column D contents (not overwriting data but mixing) creativetechguy Microsoft Excel Misc 2 5th Aug 2004 07:32 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:37 AM.