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.