|
![](/i/fill.gif) |
And lo On Thu, 17 Feb 2011 14:53:02 -0000, bart <bar### [at] home org> 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
|
![](/i/fill.gif) |