Align Rows Comparing Multiple Columns

Hi,
I would like to align rows in an spreadsheet. The spreadsheet has multiple columns which has data which needs to be aligned. I have added a spreadsheet with 2 tabs . One is input tab and the other is output tab. I would like to get the data formatted in the input tab to the one which looks like in output tab.

I would like to run a macro to get the output, the number of rows in each column are not fixed. they change depending upon the data.

Thanks in Advance.

Here's an alternative; it's a generic sorting routine that will produce output for any matrix of data in an active sheet and sort by numbers, then capital letters then lower case letters ... and displays the linear list of values in a column to the right of your data and also the 2 dimensional sorted matrix underneath your data.

Please Login or Register  to view this content.

Hope that helps. MM.

OK - an attachment always helps My question is: Is the first ID for each set of data unique within the individual data? That is, for each dataset SP1, SP2, SU1 etc .. can there ever be two ID_id1 values the same? Such as - having ID_id1 = 40_1 twice, with different combinations of the other IDs (ID, id1, id2)?

Hi deaerator ... OK, I think this will do what you're after. The code is below; just paste it into the workbook object, and I've attached the workbook I used to test it. This is the main control module:

Please Login or Register  to view this content.

And these are the others the control module calls:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hope that helps. MM.

Thank You MM. Works like a charm. Thanks so Much...