Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help with code (2003)

    Hi,
    I am struggling to code the attached. My raw data (sheet 1) needs to be coded to look like sheet 2. Anything with a correct account number moved to bottom with colour, anything without correct account number remain at top without colour. a few blank rows between. Then sort top data set by I and bottom data set by C.

    I have tried different methods using filter cut and paste and without filter but i am tying myself up in knots both ways.

    Help please....
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help with code (2003)

    You could add formulas in column M: in M2 =ISBLANK(L2), and fill down.
    Then sort descending on column M.
    It doesn't do all you want, but it does sort the correct account numbers at the bottom, and you don't need any code.

  3. #3
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help with code (2003)

    Hans,
    Thanks for the option, but this is a small section of a much bigger piece of code that I have been building. I wan't to be able to do the whole task with one click, so I will keep plugging away. Cheers..

Posting Permissions

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