referece the cells in sheets 1 and 2 like this:

=Sheet1!E22

"Tabis" wrote:

I have 3 worksheets. First one with budgeted sales, second with actual sales
and I need to use a 3D reference to get the variance on sheet three.