Help with code (2003)

Topic

New Reply

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….

Reply | Quote

Replies

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.

Reply | Quote

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..

Reply | Quote