making macro resident in memory

  • Thread starter Thread starter cawemann
  • Start date Start date
C

cawemann

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
 
Cawemann said:
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.
Click to expand...

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
 
Back
Top