Combining Multiple Columns

[ikflash]

Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I have data in columns A - BM<o></o>
<o> </o>
I need a macro which deletes columns A – W, Z – AC, AF – AI, AL –AV, AZ – BD, BG – BK.<o></o>
<o> </o>
This should leave data in columns A – L<o></o>
<o> </o>
I then want the data in columns C,E, G,I & K moved to column A<o></o>
<o> </o>
I also want data in columns D,F,H,J and L moved to column B

So it will be left with data in Columns A and B.

Hope this make sense.

 

[Tom Urtis]

The macro recorder should produce the code you want. Try that and see if it works for you, and if not, post back why not.

 

[ikflash]

Thanks for the suggestion, I have no trouble deleting the rows its moving all the data into two columns that I struggle with.