+ Reply to Thread
Results 1 to 1 of 1

Drawing revisions code?

Hybrid View

  1. #1
    Registered User
    Join Date
    01-26-2013
    Location
    stockholm
    MS-Off Ver
    Excel 2007
    Posts
    1

    Drawing revisions code?

    Hi everyone! Hope someone can help me with this issue I've been dealing with for weeks now.

    I have a column for drawing revision letter (A, B, C, D etc where D is the latest updated drawing) and another column for sequantial number that starts with 1 and is going to have updated rows under it with 1.1, 1.2, 1.3, 1.4 etc.

    I hope there is a macro code that can run this sequence (when I click on Update Revision button it runs macro that inserts a new row WITH A as first revision and sequantial number (1.1), when I click for the second time I get a new row under the first one with B as my second revision and sequantial number 1.2 etc.)

    My first row with sequantial number 1 has formula =IF(COUNT(G4:H5);MAX(G4:H5);LOOKUP(2;1/((COUNTIF(G4:H5;">"&G4:H5)=0)*(G4:H5<>"-"));G4:H5)) that returns the latest revision letter in the added rows underneath it. How do I do to make G4:H5 to extend and include all the added rows underneath it??
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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