View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amateur Amateur is offline
external usenet poster
 
Posts: 7
Default Formulas between worksheets

FANTASTIC. THAT'S IT.

Thanks very much. I really appreciate the time you spent figuring it out.

"Glenn" wrote:

Amateur wrote:

xlmate: I agree, I would have expected the formula to read =Budget!J60*2.
When I click on the cell in the budget worksheet it reads =Budget!J60 but as
soon as I select the savings worksheet it changes to =Savings!J60

Still a mystery.



After clicking on J60, just type "*2" and hit enter. DO NOT reselect the other
worksheet.