View Single Post
  #4  
Old 01-30-2012, 10:16 PM
Yak Yak is offline
Registered User
 
Join Date: Aug 2009
Location: San Antonio, TX
Posts: 1,711
Quote:
Originally Posted by tbomachines View Post
Can't you just redefine the variable on the second page as the same thing, or basically use the same reference?

on page 2
='Page1'!currentPwrcost
Does "page" substitute for "sheet"?

Hypothetically, say you've got your variables in sheet 1. cost/kwh is sheet 1 cell A4. Sheet 2 is server X, sheet 3 server Y, etc. Say you've got forecast kW in B4 on sheet 2 and you need a dollar value in cell C4. Is that sort of how you're setting it up?

I think tbo's comments are basically correct and to calculate the rate*demand you just need

for sheet 2 cell c4 it would be =sheet1!A4*B4

Copying and pasting SHOULD do this for you. If the sheets have names like "variables, server X, server Y" then you may have to replace the sheet number with the name. Don't underestimate the power of "paste special" and then pick your options, like "paste values". That simply pastes the numeric value of the cell and reduces broken references. But that's a one shot deal. If you change the original cell later on, it won't propagate.
Reply With Quote