Create a Macro from predefined text

Hello people.

LV Final.xlsx

So, this is the file I have. If you open the "Macro" sheet, that's an example of the data I'll need to transform. So, it has to look like this:

Please Login or Register  to view this content.

So, step-by -step:

Take that title above (cell B2) and put it between that code;

Get a position in the left, get the country in the same row and put it in the [flag][/flag] code, take the name in the row between the , then input the arrow and the number of points: do that to all the positions (the number of them can vary from 3 to more than 30), same with "Líder";

Then we have the teams after the "Pontuam:", these are the teams of the riders, which are the ones who get points. So, name of the team and points in the same row. I'd like to see the teams ordered by points (as you can see, in the code Orica appears before Fly V because it has more points, although in the file Fly V is in the first row with positions: the second rider having more points than the first is not an error!). If the same team appears twice, I would also like to see a sum like the one Fly V has in the code.

Hope I was completely clear, thank you in advance.

not valid attachment

What kind of ouput do you want ? a text file ? a new sheet ?

Originally Posted by Helders

If the same team appears twice, I would also like to see a sum like the one Fly V has in the code.

i'm sorry but it's a problem for me, maybe you can arrange this code

Please Login or Register  to view this content.