Howdy all,

I don't think this would be hard but I don't know how to code it...

Here's the scenario.
I have a worksheet with static data on it and one that calculates totals for
various things that change all the time. In the static sheet there is a cell
that contains the value "1 Total". In the other sheet there is also a cell
that contains "1 Total" but it's not always in the same place.

What I need to do is take the cell to the right of the 1 Total cell in the
static sheet and get the value of the cell to the right of the 1 Total cell
in the sheet that has things move around.

How can I do that?

Thanks!!