Leith,

You are right I removed them thinking it was messing up the sort.

Yes I want to sort the data by COL. A "SCT#" but I want to keep the data in all of the rows the way it is just sort/move the blocks of data if you will. That is the hard part with the outlines.

So the data is made up of many blocks i.e. - A7 to L9 is one of these "Blocks" and as you can see they are just copied and then the data is changed or added in them.

I want to sort these "blocks" by the value in COL. A but keep the data in the blocks, maybe move the blocks? I do not know.

I know how to do a normal sort but the way I need to keep the data in the same location within the blocks and just move/sort the blocks depending on COL. A is what has me stumped.

Thank for your help.