Selective sorting

**drgogo** · 04-28-2009, 03:48 AM

Had a brainwave last night, an is this possiable.

IS it poss to sort an entire sheet by one column then another, but to exclude certain rows that include certain data.

This is what i mean, I have a sheet where data is entered on a daily basis. this data has tobe kept with in its dates. Each day starts with a start time and ends with an end time, and on occasion a break is included within the data. then between dates there is a blank line.

IS it poss to sort the data and exclude the blank lines and the start, end and breaks within the data, but keep the data within date, so all data for the 12/4/09 stay within this block...????

**oldchippy** · 04-28-2009, 04:08 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**drgogo** · 04-29-2009, 03:51 AM

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.