The original quotes workbook has a front sheet which is a customer record which updates the rest of the workbook which has customer information in it. Then the quotation has several sheets with corrosponding info in them to creat the quotation at the end.

will your code update the Log Workbook on a new row each time the Quotation Workbook is opened and data is entered?

I am a bit of a thicky when it comes to this but where do i put this code in the VBA?

Sorry to sound so thick!