Hi cjaye,

See attached. All you need to do is to insert each month's data on the 'Mileage History' sheet. Even the dates on that sheet are calculated automatically by copying the formula in column A down. Assuming you have more vehicles to monitor, simply add extra columns for them on the 'Mileage History' sheet and copy columns A:G on the 'Main' sheet.

Attached Files

cjaye.xls (33.0 KB, 11 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I was looking for a way to automate the whole process of capturing the history onto that Mileage History sheet. I don't want the administrator to have to manually copy data to the sheet (if I understood you correctly). My vb code above in the third post, copies the data to the history sheet and puts the current month heading in. This is done when she clicks on the macro button to update the Current Mileage column to the Previous Mileage column. Where it falls short is if a new vehicle is inserted or deleted. Not sure how to handle that...that's why was trying to try another method...like sycning the two sheets.

Thanks again for your help.