Heres the problem ... :) (simple but long to explain..)

Col A, B, C, D, E are single columns
Col F,G are merged
Col H single column
Col I,J,K are merged
Col L,M,N are merged
Col O,P,Q are single columns

Data within Column D is one of 8 types.
Depending on users choice in Column D he/she would have got a different
set of choices in Column E

I have completed submissions - ie users have selected data from Column
D, and corresponding data from Col E. Thus I have one file (from lines 1
to say 200) with the users choices in it.

All I want to do is sort by Column D and then by Column E - Excel wont
do it because of the merged columns. If I unmerge the columns
formatting etc is destroyed (I would then need to re-merge them after
sort - but that is manual process, clicking each of 200 lines saying
merge (and its remerging col I,J,K and remerging L,M and N)

So is there any easy solns anyone can think of how to sort merged data?
(is there perhaps VBA that could go down Three columns, and then merge
cells on a row by row basis? )

Appreciate your Input Immensely!!!

I know I could manually autofilter col D and then Col E and copy and
paste into a new book for each of the choices - but that is a massive
task.

Regards

D

*** Sent via Developersdex http://www.developersdex.com ***