TerryJ wrote: > > > 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.
Not a bad idea at all. Tnx Terry. Users can now get the file with a file ID of 1282246. > When providing the link, please identify by name the sheet which is the > "master sheet". The Master sheet is named as such and is the second sheet in the file. :) --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
