Calculating value across multiple worksheets
Hi folks,
{Using Excel 2000}
I'm trying to calculate a value across three worksheets.
For example, I have three worksheets named:
"CostPrice" - the wholesale price
"Markup" - the profit markup in %
"RetailPrice" - the calculated result of (CostPrice + Markup)
It's been along time since I've used Excel (V4?) in this way, but I'm sure I
used to be able to point and click my way through the various worksheets and
Excel would build the correct formula for me. When I try this now I receive
a #VALUE error in the "RetailPrice) cell.
Any guidance much appreciated.
Cheers -- Neil
|