Hi Guys
I am looking for some help with finding some content within a column and re-arranging the order of the found rows to a specific order.
To make it a bit clearer please see below
<tbody>
</tbody>
The cells I need to reorder will always be in column 2 and will always be in the same order starting with "tom" and ending with "lee"
I would like to run a macro to find the relevant rows and all the relevant columns to the right and reorder them in the following order
<tbody>
</tbody>
in the above examples the cells with code1, code2 are for example only, in reality they will be various numbers.
Hope this makes sense
Thanks for any help
I am looking for some help with finding some content within a column and re-arranging the order of the found rows to a specific order.
To make it a bit clearer please see below
score1 | score2 | score3 | score4 | score5 | score6 | score7 | ||
text | text | text | text | text | text | text | ||
123 | red | number | number | number | number | number | number | number |
124 | blu | number | number | number | number | number | number | number |
125 | grn | number | number | number | number | number | number | number |
126 | ora | number | number | number | number | number | number | number |
127 | bla | number | number | number | number | number | number | number |
tom | code1 | code1 | code1 | code1 | code1 | code1 | code1 | |
ann | code2 | code2 | code2 | code2 | code2 | code2 | code2 | |
alan | code3 | code3 | code3 | code3 | code3 | code3 | code3 | |
ellie | code4 | code4 | code4 | code4 | code4 | code4 | code4 | |
mary | code5 | code5 | code5 | code5 | code5 | code5 | code5 | |
dave | code6 | code6 | code6 | code6 | code6 | code6 | code6 | |
lee | code7 | code7 | code7 | code7 | code7 | code7 | code7 | |
<tbody>
</tbody>
The cells I need to reorder will always be in column 2 and will always be in the same order starting with "tom" and ending with "lee"
I would like to run a macro to find the relevant rows and all the relevant columns to the right and reorder them in the following order
ann | code2 | code2 | code2 | code2 | code2 | code2 | |
mary | code5 | code5 | code5 | code5 | code5 | code5 | |
ellie | code4 | code4 | code4 | code4 | code4 | code4 | |
alan | code3 | code3 | code3 | code3 | code3 | code3 | |
tom | code1 | code1 | code1 | code1 | code1 | code1 | |
lee | code7 | code7 | code7 | code7 | code7 | code7 | |
dave | code6 | code6 | code6 | code6 | code6 | code6 |
<tbody>
</tbody>
in the above examples the cells with code1, code2 are for example only, in reality they will be various numbers.
Hope this makes sense
Thanks for any help
Last edited: