Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to write a formula once in one sheet and have others call that formula and do calculation in their own sheet. I want to do this because calculations need to be done in 100 other sheets within the same document but I dont want to have the change the formula in everyone of those sheets if we decide to modify it.

Thanks!

share|improve this question
    
Do you mean other sheets within the same document or across different documents? – ChrisF Oct 7 '10 at 20:59
    
Within the same document. – dotLoom Oct 7 '10 at 21:17
    
In Excel to refer to a cell in another sheet you use: =Sheet1!B7 (for example) but I'm not sure how this helps you in your case. – ChrisF Oct 7 '10 at 21:29
    
Doing that doesn't bring the formula over it brings the value over. – dotLoom Oct 7 '10 at 21:30
1  
If you associate your Web Apps and Super User accounts you'll regain ownership of the original question. – ChrisF Oct 8 '10 at 22:27

Excel doesn't have a built-in to return the formula, you will have to use this user defined function.

share|improve this answer
    
Does anything like this exist for Google Docs? – dotLoom Oct 7 '10 at 22:39
    
No, Nothing built in or user defined, you'll have to build a script – Sathya Oct 7 '10 at 23:03
    
I was trying to build a custom function =CopyFormula() but it the scripting API forbids us developers from grabbing data from any cell other than the current active cell when using custom functions, so I doubt this will be possible in Google Docs – Sathya Oct 8 '10 at 0:44
    
Thanks for trying. How do I use this? code.google.com/googleapps/appsscript/… – dotLoom Oct 8 '10 at 3:10
    
@dotLoom This is what I had came up with, while trying to create that custom formula pastebin.com/qVcgBufV – Sathya Oct 8 '10 at 3:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.