And lo On Thu, 17 Feb 2011 14:53:02 -0000, bart <bar### [at] homeorg> did spake  
thusly:

>>> Yes it's a common technique to put 'workings out' on another sheet and
>>> then hide it; the formula is "=SheetName!Cell"
>>
> It also could be placed in another file, like
> "='C:\temp\[Book1.xls]Sheet1'!A1"

or =[FileName]SheetName!Cell if it's in the same folder; just makes folder  
integrity a little easier if you're having to pass it on to someone else.

-- 
Phil Cook

--
I once tried to be apathetic, but I just couldn't be bothered
http://flipc.blogspot.com

Post a reply to this message