making macro resident in memory
 

i must make a table with domains "student name", "student ID", "quiz 1"
"quiz 2", "average" and "%". when i enter values into quiz 1 and quiz
the program must automatically grab them, apply some functions an
write the results into average and %. i can make this simply by usin
excel functions. but i must do this with macro. i think i must loa
macro to memory in order to do this. but how? please, i need ver
urgent help :confused

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

making macro resident in memory
 

Cawemann wrote:
i must make a table with domains "student name", "student ID", "quiz 1",
"quiz 2", "average" and "%". when i enter values into quiz 1 and quiz 2
the program must automatically grab them, apply some functions and
write the results into average and %. i can make this simply by using
excel functions. but i must do this with macro.


Not clear why you need a macro.
I would enter functions in the average and % column which produce the
desired answers when quiz1 and quiz2 figures have been entered but show as
blank otherwise, e.g.

=IF(COUNT(C3:D3)=2,(C3+D3)/2,"")

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup