Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting Data.... Help!!!!
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 *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data | Charts and Charting in Excel | |||
Help please - Data sorting | Excel Worksheet Functions | |||
Sorting data to match existing data | Excel Discussion (Misc queries) | |||
colors of bar charted data don't follow data after sorting | Charts and Charting in Excel | |||
help on sorting data | Excel Discussion (Misc queries) |