VBA Help with Selective Sorting

[drgogo]

Please find attached a example spreadsheet of what im trying todo

There are two tabs, one showing the before sort and the other showing what it should look like after the sort.

The sort command will be a macro within a custom menu on the tool bar, which is not shown on the example.

What i need is a sort function that will sort the whole page first by column D then by column E.

But what i need is for the sort to exclude the blank rows, and rows which are Breaks, Starts and ends, there is also a section for route checks which also need to be excluded.

So the only data that needs to be sorted is the data that has a ref number ( column A) but it need to look like the after sort page when done. As you will see the data stays within the dates but sorted.

Hope this explains every thing

if not i can provide more information

G

Oh columns A, I and J are locked and the worksheet is protected, but not this example.

[JBeaucaire]

Give this macro a run on your protected worksheet:

Please Login or Register  to view this content.

[drgogo]

It working..

Thanks, I take it that this will do up to the maxium rows, the sheet is set at 3000 rows at the moment, but over th ecoming years could be increased. So i take it that this code will still cover that.

again thank you very much, I'll get my users to test it to see if it is fool proof

Thanks for your help and time

Will get back to you once i have had a full test

G

[drgogo]

been giving the macro a serious test and its working well

Only problem is when i first run the macro a Unprotect Password msg box appears asking for a password.

Whats the editing required to stop this msg box from appearing, but still keeping the sheet protected and locked???

G

[kvrs09]

=Stdev(if(A1:g400>34 and a1:g400<54))

[JBeaucaire]

I would have thought you would want to keep your password OUT of the macro and entering it once the first time you use the macro would be preferable. But if not, add the password in like so:

Please Login or Register  to view this content.