View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
neilr
 
Posts: n/a
Default 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