Linked data and sorting

Hi there,

I have an issues that we cannot find a solution to - if there is a solution. Or if there is a different approach required.

We are trying to make an issue sheet for our architectural drawings and reports etc. The drawings come from different areas, so we need to combine them into one issue sheet.

I have attached 2 cut down files. The first one is a Document Creator.XLSM. In here there are 3 sheets with data (Titles, Drawing Numbers etc.). There is a 4th tab with VBA to consolidate all the data from the first three sheets. I didn't write the VBA, but it seems to work well - it combines all the data when you save the workbook.

The 2nd XLS, Issue Sheet.XLSX has formulas to pull the data from the first workbook, Consolidated sheet. The links won't work for you as they are relative to my folder structure. What is then there is manual data entry to columns to the right of issue dates and issue revisions down the columns relevant to the drawings being issued.

This works fine, UNTIL you add a new data row into any of the first three sheets of the Document Creator. This means that when the data is updated in the issue sheet, the manual revisions added will lose the row they were intended for.

I hope this makes sense as a description !

Could anyone please suggest a way to be able to add to the Document Creator and get the revisions to stay with the correct row ??

Please be a lifesaver :-)
Thanks.

Try replacing the code in the Thisworkbook module with this...

Please Login or Register  to view this content.

Thanks for helping dangelor - place the code in the Document Creator or the Issue Sheet ?

Document Creator