Two lists from one.

[boomshaka]

[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
I need help turning one list into two. Can you help?

[TABLE="width: 451"]
<colgroup><col><col><col span="3"><col><col></colgroup><tbody>[TR]
[TD="colspan: 2"]Original List [/TD]
[TD] [/TD]
[TD="align: left"]List 1[/TD]
[TD] [/TD]
[TD="align: left"]List 2 [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Planned [/TD]
[TD="align: left"]PO 1[/TD]
[TD] [/TD]
[TD="align: left"]Planned [/TD]
[TD="align: left"]PO1[/TD]
[TD="align: left"]Break Even [/TD]
[TD="align: left"]PO2[/TD]
[/TR]
[TR]
[TD="align: left"]Break Even[/TD]
[TD="align: left"]PO 2[/TD]
[TD] [/TD]
[TD="align: left"]Planned [/TD]
[TD="align: left"]PO2[/TD]
[TD="align: left"]Break Even [/TD]
[TD="align: left"]PO3[/TD]
[/TR]
[TR]
[TD="align: left"]Break Even[/TD]
[TD="align: left"]PO 3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Planned [/TD]
[TD="align: left"]PO 4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Planned [/TD]
[TD="align: left"]PO 5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Break Even[/TD]
[TD="align: left"]PO 6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Break Even[/TD]
[TD="align: left"]PO 7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Planned [/TD]
[TD="align: left"]PO 8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Planned [/TD]
[TD="align: left"]PO 9[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Break Even[/TD]
[TD="align: left"]PO 10[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Break Even[/TD]
[TD="align: left"]PO 11[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Planned [/TD]
[TD="align: left"]PO 12[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Planned [/TD]
[TD="align: left"]PO 13[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Break Even[/TD]
[TD="align: left"]PO 14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Break Even[/TD]
[TD="align: left"]PO 15[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: left"]Planned [/TD]
[TD="align: left"]PO 16[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[boomshaka]

Sub Make2Lists()( Highlighted)​

 

[boomshaka]

I kept pressing FB and I get an Application Defined or Object defined Error

 

[Fluff]

Did you get an error message?
If so what was it.
If not press F8 again & again until either the macro finishes, or you get an error message.

 

[boomshaka]

Application-defined or object-defined error when .formula

When we get to this section of the code.

.Replace True, Ary(i), xlWhole, , False, , False, False​

<strike></strike>
​

 

[Fluff]

As there is not line with .formula in the code I posted, could you please post the code that you are using.

 

[boomshaka]

That is the exact line that you sent me. Could you check again please?

 

[Fluff]

Do you have any merged cells in column A