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
