Excel Sort Issue

[zloki83]

I have groups of data i need to sort by date or type. The data below
would be in excel in columns and rows. How would i sort by date? or by
time?

Date:8/20/08 Time: 5:00
Candy enjoyed?
snickers Y
milky way Y
baby ruth N

Date:8/15/08 Time: 3:00
Candy enjoyed?
3 musket Y
m&m N
baby ruth N

Date:8/30/08 Time: 4:00
Candy enjoyed?
Clark Y
Crunch Y
Hershey N

Thank you for all your help.

 

[Don Guillett]

I would suggest re-ordering into 10 columns. Then, sorting is a breeze
A macro can be designed to re-order your groups into the 10 columns.

 

[zloki83]

I would suggest re-ordering into 10 columns. Then, sorting is a breeze
A macro can be designed to re-order your groups into the 10 columns.

How would that macro be programed? would it be able to account for if
the number of candies were different for each subject?

 

[Don Guillett]

There may be too many ifs, ands and buts but I can't tell without seeing the
file. If desired, send to my address below and I'll try to take a look.
Feeling poorly today.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

I would suggest re-ordering into 10 columns. Then, sorting is a breeze
A macro can be designed to re-order your groups into the 10 columns.

How would that macro be programed? would it be able to account for if
the number of candies were different for each subject?