Cam
You ask "Is there a way that i can create a macro that records the number
of correct answers and displays it in a table?" Yes, but you don't provide
sufficient information for someone to write the macro for you. For
instance, what constitutes a "correct" answer? What does the test taker do
to enter an answer?
You say "Each time the user opens the workbook the cell contents are
'cleared' but the information is saved as an entry in a table which is
displayed on thr first page." I know this makes sense to you because you
wrote it, but to someone who knows nothing about your business it makes no
sense.
You say "I have made an entry which totals the score on the first page.
and it could incorporate the function =DATE() to provide a column entry?"
Again, this makes no sense except to you.
I am not being critical of what you wrote just to be critical of what
you wrote. All of us in these newsgroups want to help. That's why we look
at these newsgroups and read what you wrote. But you must approach your
task of explaining your question just like you would if John Doe just walked
in off the street. He knows nothing about your business or about what you
are asking and you want him to help you. Please post back and tell us what
you would tell John. HTH Otto


"Cam Neeson" wrote in message
...
background; I have created a quiz that tests professional knowledge based
on
a series of questions over a number of sheets (say 20 Q's per sheet).

Is there a way that i can create a macro that records the number of
correct
answers and displays it in a table. Each time the user opens the workbook
the
cell contents are 'cleared' but the information is saved as an entry in a
table which is displayed on thr first page.

I have made an entry which totals the score on the first page. and it
could
incorporate the function =DATE() to provide a column entry?

is this possible, is further info needed?

TIA