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

automatic copying of cells ?
 

KK,

Do you have any hidden columns in between the two that do and the two that don't 'copy down'
automatically?

HTH,
Bernie
MS Excel MVP


"KK" wrote in message
...
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