I did this using relative addressing - just do the formulas based on the current cost figure and the difference between the current (in the current row) and previous odometer reading (in the row above). Then duplicate the formula(s) down the chart and fill them in as you go. You will get errors for the places you haven't filled in, but the user should know enough to ignore these (unless he's like me and has a senior moment...). :) -- Phil
On Monday 23 January 2006 21:46, Anthony Chilco wrote: > Hi Bob, > I think that you will have to use a macro to do this job. Any cell that > gets the results will have to contain a number only, not a formula, or > it will change again when the $/K changes next time. A macro could be > run any time the spreadsheet changes and put the $/K in the last unused > row of a column if it is not the same as the previous last value. Having > said all that, I know it's possible, but I don't know how to do it. > tc > > Bob wrote: > > I have a spreadsheet set up for keeping track of my vehicle expenses. > > I have programmed one particular cell to show the cost per kilometer > > of driving the vehicle. Of course, everytime I make an new entry on > > the sheet, this cost changes. Can anyone suggest a formula that will > > extract this cell's information each time it is updated, and put it in > > a column so that the cost can then be charted over time? > > > > TIA, > > Bob --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
