Excel VBA - Problem calculating and passing values to another worksheet

[DanielCox]

I am setting up a worksheet to manage gradebooks for my school. Sheet
contains the student scores. Each column of scores is identified by on
of six different activities (homework, tests, etc). I am using th
activity identifiers to allow weighting averages. Sheet 2 is a summar
sheet which shows the totals for each activity and averages the weighte
scores.

I am able to calculate the averages for each student using SumIF an
CountIF functions. However, I am stumped trying to pass the result t
Sheet 2 in order to finish the calculations. I want to pass th
calculated result only, in order to allow the option of calculatin
based on weighted or straight averages on Sheet 2.

I'm guessing there must be a way to pass the result using variables
but I just haven't been able to figger it out! HELP! -- School start
next week and my teachers are counting on me.

Daniel Co

 

[Frank Stone]

If you are just tring to pass the value of a cell on
sheet1 to a cell on sheet2:
data is in a1 on sheet1 and you want it on sheet2 a1.
on sheet2 in Cell A1 enter:

=sheet1!A1