VBA Help

Hi, 

I'm trying to improve some process within my team. 

One of these is with an excel spreadsheet that tracks document reviews. 

In column D a reference number is auto generated and in E a version number is auto generated. This is due on reference number can have several reviews. 

I've created a VBA to allow it to get round the auto generation of numbers to duplicate the reverence number and other information as a lot of this wont change. The problem I'm having is that with some of the formulas in the table the VBA is causing issue with structured referents. I also need the cells to be editable and cells with dates to remain blank. not sure if this can work but any help will be apricated. 

I might be over complicating things, but I'm trying to prevent a lot of mistakes my team are making. 

I've uploaded a copy of the sheet 

Thanks