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. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
