Sort row but keep adjacent cells tied to sort cell

[PY_]

Hello,

I am not even sure if it is possible but it will save me alot of work if it is.

I am trying to sort a row in ascending order but i need to only sort the cells contaning numbers and keep the adjacent cells containg text on either side of the numbers next to the original cell i am sorting. This will be done on multiple rows and multiple columns.

Go from this:

Texta | 3 | Textb | Textaa | 5 | Textbb | Texts | 9 | Textsa | Textg | 1 | Texth |

To this:

Textg | 1 | Texth | Texta | 3 | Textb | Textaa | 5 | Textbb | Texts | 9 | Textsa |


Note: It will always be in the same order as above (text, number, text, text, number, text, etc)

I attached an example. I also made a cross post in another forum here:
http://www.mrexcel.com/forum/showthr...31#post2431031

[6StringJazzer]

I can think of no way to do this with built-in Excel features (though maybe someone else can). I could write some VBA to do this if you answer one question. Your example just shows one row. With multiple rows, is each row sorted independently?

Is this a one-time job, or will you need to do the same thing repeatedly?

[PY_]

Multiple rows independently

Similar to the following:

Please Login or Register  to view this content.

Etc..

It will need to be ran on a single Workbook after the user Calls the macro (by pressing a button i create) whenever the data needs to be exported.


I basically have alot of data being gathered from multiple sheet tabs into a single sheet tab. Once gathered, i need to sort it all (using the above method), clean it all up by removing blanks cells/rows/columns, and finally export that sheet tab to a csv file. This will be done on a per job basis so the numbers i am sorting will always be different but the cell locations remain the same.

[PY_]

Here is a final sample file without sort. The sorting will be done on this file before saving as a csv.

The "XMRX" is just a filler that gets deleted.

The sorting is done from J:HW on multiple rows all individually


XMRX gets deleted and shifted left by the following:

Please Login or Register  to view this content.

[PY_]

An answer has been found here:

http://www.mrexcel.com/forum/showpos...92&postcount=2

[6StringJazzer]

PY_, thanks for posting your resolution. I apologize that I have been too busy to get back to you on this one.

[PY_]

The 03 version doesnt seem to sort correctly. I tried to figure out why but so far no luck (VBA noob here). It does the copy to the vertical column and then copy back into the cells correctly just the sorting seems to flip flop cells around for lack of a better term.

I can use the 07 and just make sure i call up 07 before running the code whenver i need it. Thanks again for the help!