View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
KK
 
Posts: n/a
Default automatic copying of cells ?

Hello

I have a simple spreadsheet which monitors my car's fuel costs, mpg etc.
Each row has 4 cells with input data (date, mileometer reading, litres,
cost) and 8 calculated cells (eg. mpg, cost/mile, pence/litre,12 month
average mpg, etc. etc.).

Whenever I add a new row I type in the 4 input cells and find that 2 of the
calculated cells seem to automatically 'copy down' . The other calculated
cells have to be copied down 'manually'.

Can anybody tell me what is going on ?

Thanks

KK