TButhe
06-14-2005, 02:27 PM
I am trying to use the code in this KB article http://www.vbaexpress.com/kb/getarticle.php?kb_id=479#instr . I am having trouble because I need to sort three columns - that part is ok - but what happens is that it sorts after the first cell is filled and that would be great but the user will need to fill 3 columns before I want the sort to happen. So in column A they will enter the date in this format mm/dd (month and then day, sorry if that is TMI but want to be clear) in the next column will go the client name and in the third column would be the type of activity that is happening, really just a code anywhere from 1 - 4 characters. Then I want the sort to happen. How would i modify this so that the sort happens after the 3rd column is filled in? What am I missing?
I have attached a copy of the file - I know it is ugly but I am still just learning! As always - Thanks!!
BTW - nice code mdmackillop!!! :clap:
I have attached a copy of the file - I know it is ugly but I am still just learning! As always - Thanks!!
BTW - nice code mdmackillop!!! :clap: