Hylton Conacher(ZR1HPC) wrote:
>
> Sorry for the delay in replying.
>
> TerryJ wrote:
>>
>>
>> Hylton Conacher(ZR1HPC) wrote:
>>> TerryJ wrote:
>>>>
>>>> Hylton Conacher(ZR1HPC) wrote:
>>>>> Hi,
>>>>>
>>>>> I have a complex spreadsheet system ...
> <snip>
>
>>> If no one else has any ideas, I have decided to put up with changing the
>>> cell formula instead of linking them. The $ you mentioned, solved most
>>> problems, and the rest can seemingly only be sorted out via checking
>>> each sheet individually and adapting the formula therein as there re too
>>> many variables in the formulae.
>>
>> You can't give up that easily. I have problems following Help and
>> HowTos.
>> If you ever try Linux, you will discover one of the most frustrating
>> experiences known to humankind is trying to make sense of "man" pages.
> I have been 'using' Linux for over a year, but have to admit mainly the
> KDE GUI. Those 'man' pages can sometimes be frightening :)
>
>> I find the best way to work out how to use something is to start trying.
>> This is a simple example:
>>
>> In Sheet1.A1 type some data.....
> snip>
>
> I tried the example but got a couple of 502 errors. I gotta say the
> INDIRECT function seems nice but I am unsure how it is going to help me.
> To me it seems the INDIRECT function is referring to the value of
> another sheets cell but requires the referenced cell to be defined in
> another cell?
>
> I would assume that I could use the INDIRECT function on each sheet to
> create a link to the Master template formulae? The problem comes in
> where I must not use the data on the Master sheet but the data of the
> sheet where the formula is pasted. Seems to me like a copy and 'paste
> special' without selecting 'Link'.
>
>> Having said that, I should belatedly ask about your example
>> =Sum($Totals-<month name>.d2). Is the <month name> part of a sheet name
>> and
>> why use SUM for what seems to be a single cell?
>
> Sorry, error in the above formula. Copying the formula from cell E5 from
> the current sheet named(Apr) gives:
>
> =SUM(($Totals.B5-SUM(D3:D4))/(30-COUNT(D3:D4)))
>
> I still do not see how implementing the INDIRECT function is going to
> allow me to link to the Master sheet formulae but use the data from the
> sheet that the formula is pasted onto.
>
>
Ok. I admit that I've got no idea now what you're trying to do. I take it
the document has changed since you provided a copy previously. How about
uploading a copy to http://www.mytempdir.com/ and providing a link. Not
everyone on the list wants to receive a copy.
When providing the link, please identify by name the sheet which is the
"master sheet".
--
View this message in context:
http://www.nabble.com/Varying-sheet-specific-master-formula--tf3475042.html#a9836163
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
