Tell me more ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.
up vote 2 down vote favorite

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
show 2 more comments

1 Answer

up vote 1 down vote

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
show 6 more comments

Your Answer

 
discard

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