spliting text

I have found a spreadsheet with a fixture list on you input the number of teams on sheet 1 and it print outs the fixture list on sheet 2.

What i would like to do is have the home team on cell a and the away team on cell b, can somebody take a look at it and see if they can help me with this i have included the sheet.

Sheepkin_Coat,

I have attached a modified version of that spreadsheet that splits the names into two columns.

Hope that helps,
~tigeravatar

Originally Posted by tigeravatar

Sheepkin_Coat,

I have attached a modified version of that spreadsheet that splits the names into two columns.

Hope that helps,
~tigeravatar

Could you explain where you made the changes please, also if the team has a space in it like Aston Villa then lla goes onto the b column

And Thanks

Sheepkin_Coat,

Thanks for the tip, I hadn't thought about a space in team names, that has been fixed in the attachment to this post.

As for where the changes are:

In Sub FillList(ByVal NumPlayers As Integer) I added the following code:

Please Login or Register  to view this content.

That code calls a UDF titled SearchString, which I added at the bottom of the module:

Please Login or Register  to view this content.

Hope this helps,
~tigeravatar