On Thu, 26 May 2005 15:15:50 +0200, Ennio-Sr wrote: >[Probably duplicates previous message sent 21st May] >* GregChi <[EMAIL PROTECTED]> [200505, 15:46]: >> In a check register I want a formula in cell A1 to show the last >> value in the column(D?) that is the current balance. As more data is >> entered this last item will be shifted down. Until data is entered the >> cell is empty. >> Is there a function/formula for this? > >Hi Greg, >maybe you could put '=balance' in cell A1 and then, after entering all >your data, define col D? as a named range 'balance' ? I think you could >also automate this with a macro. > >Regards, > Ennio.
Where do you find 'balance' in the functions? (1.1.4 & 1.9.7.9 don't show this) Is this an addon? How would I go about making this? -- Greg Agent 1.93/32.576 Opera 7.50 3778 OOo 1.1.2 news.individual.net & news.gmane.org Win98se for sale: Apple//,Auto Parts/Equip/Manuals: http://[EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]