sorting a row of strings

[wlan11g]

Hey guys,
------
I need help in programming a simple row search within a list that searches for key strings within a current row, and if found, place that cell and its adjacent cell in sorted columns

below is some pseudo code for how i think the program should look like but see the example worksheet for how it should eventually look like on a spreadsheet.
------

Please Login or Register  to view this content.

Few notes:

- Each key string cell will always have a corresponding data cell adjacent to it
- Each key string cell will only appear at most once per row
- The key strings are usually out of order
- Rows will need to be preserved
- Each row will have at least one key string
- Sorting the rows can be done within the same worksheet, or a new worksheet, but again, the rows need not be changed.

Thanks in advance!

[JBeaucaire]

Put your initial data set onto a sheet without all that stuff around it, so the first column of data starts at A1. Then try this macro:

Please Login or Register  to view this content.

[wlan11g]

Thanks JBeaucaire,

all working sweetly.

[JBeaucaire]

Glad to help...

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)