Insert Rows Between Names In Alphabetical Order

  • I have a spreadsheet with 3 Columns and many different rows. Such as:


    Code
    NAME                    STATE          COLOR
    
    
    Doe,John                WV              Green
    Johnson,Robert        LA               Orange
    Smith,Joe               CA               Blue

    I'm looking to have a script where I can insert "Howard,Pat MA Yellow" and have it automatically go in between Doe,John & Johnson,Robert. Is there any possible way to do this? I've tried a few things but haven't had it quite work exactly how I wanted using various loops.

  • Re: Insert Rows Between Names In Alphabetical Order


    Try this. You will have to change the sort area and may want to change the message for I added extra spaces.


  • Re: Insert Rows Between Names In Alphabetical Order


    JohnDrew,


    Please learn to use code tags properly. I've added them for you. With 73 posts in this Forum, by now you should know how to use them.


    Proper use:


    [code] code here [/ code]


    Note: I've added a space character after the / to make the tags display without the Forum interpreting them as real code tags. In practice, there are no spaces in the tags.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!