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


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

I am able to calculate the averages for each student
using SumIF and
CountIF functions. However, I am stumped trying to pass
the result to
Sheet 2 in order to finish the calculations. I want to
pass the
calculated result only, in order to allow the option of
calculating
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 starts
next week and my teachers are counting on me.

Daniel Cox


---
Message posted from http://www.ExcelForum.com/

.