+ Reply to Thread
Results 1 to 4 of 4

Linked data and sorting

  1. #1
    Registered User
    Join Date
    01-27-2020
    Location
    London
    MS-Off Ver
    2013
    Posts
    2

    Unhappy 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.
    Attached Files Attached Files

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,209

    Re: Linked data and sorting

    Try replacing the code in the Thisworkbook module with this...
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-27-2020
    Location
    London
    MS-Off Ver
    2013
    Posts
    2

    Re: Linked data and sorting

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

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,209

    Re: Linked data and sorting

    Document Creator

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sorting data which is linked to other spreadsheets
    By Flojoe in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-28-2013, 08:14 AM
  2. Sorting Times linked with two other data entries.
    By MDills in forum Excel General
    Replies: 0
    Last Post: 09-06-2012, 08:22 PM
  3. Sorting linked data
    By sarahi999 in forum Excel General
    Replies: 0
    Last Post: 07-05-2012, 12:57 PM
  4. Sorting Data in a Linked Workbook
    By renato1 in forum Excel General
    Replies: 0
    Last Post: 05-22-2012, 06:10 PM
  5. Sorting Linked data
    By PRW in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-12-2008, 09:24 PM
  6. Linked Cells Corrupted by Data Sorting
    By catmandu57 in forum Excel General
    Replies: 1
    Last Post: 12-07-2007, 03:19 PM
  7. Sorting Linked Data
    By Gorze in forum Excel General
    Replies: 0
    Last Post: 07-26-2007, 11:52 AM
  8. [SOLVED] sorting data in linked worksheets
    By Allyson in forum Excel General
    Replies: 0
    Last Post: 06-08-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1