We're looking to create an issue sheet which comes straight from VWX (We are using a separate excel spreadsheet). This is just to save us time rather than having to manually update our excel sheet every time we issue a drawing, and when you have a large amount it takes time to update all the sheets and revision number ect...
We have set up a worksheet containing all the relevant information which links correctly to the corresponding title block, however when it comes to the revision number we are having problems. The issue we're facing is that we would like the worksheet to automatically update the current revision number- however we cannot set the record field on the worksheet as 'current revision number', as all the previous revisions on the sheet will update with. Its almost like we need to the previous ones to freeze however we do not know how.
See attached the layout of our worksheet issue sheet.