Stumped
Try doing it with the what?
"Steve M" wrote:
Try doing it with the
"Jake" wrote in message
...
I am using a conditional formula to display the sum of an equation on a
different worksheet. The conditional formula looks at the day of the week
that is entered by the user to determine where to put the sum of the
equation. My problem is that when the day of the week is changed, the
data
referenced from the other worksheet will be lost. Is there some way to
reference data from a different worksheet and lock those values in place
so
they will not change when the day of the week changes?
|