Need help with a macro!

[mr.durden]

Hi there,

I have a spreadsheet which has been awkwardly formatted by a client with over 50,000 rows. I've tried creating my own macro to automate the work but it just won't seem to work (i'm probably missing something obvious).

At the moment the data looks like this:

00229268	Example 1	6089+8038
00157910	Example 2	6090+6274

<colgroup><col><col><col></colgroup><tbody>
</tbody>

I want it to look like this:

00229268	Example 1	6089
00229268	Example 1	8038

<tbody>
</tbody>

00157910	Example 2	6090
00157910	Example 2	6274

<tbody>
</tbody>

At the moment I am copying and inserting endlessly. Please help me!

Thanks

 

[mr.durden]

Hi Tiger,

Thanks for this. I tried to run it but it brought up a debug error on this line of code:

<code>For varNum = Split(Cells(rIndex, strSplitCol).Value, "-")(0) To Split(Cells(rIndex, strSplitCol).Value, "-")(1)</code>

Any ideas?