MACRO HELP: Append (Alphabetic) columns

[paugel]

I need help with a MS EXCEL MACRO.

I have SIX (6) Columns of data that range anywhere from 5,000 to upwards of 25,000 (it fluctuates; therefore, the macro needs to stop once an empty cell is hit).

The columns are "B, D, E, J, K, W".

Each column needs to be separated by a "COMMA".

Appended data needs to be placed in Column "AF"

NOTE: This is NOT alpha-numeric NOR numerical characters. This is solely WORDS/ALPHABETIC.

EXAMPLE:

ABCA (Column B)
ABCB (Column D)
ABCC (Column E)
ABCD (Column J)
ABCE (Column K)
ABCF (Column W)

Needs to become:

ABCA,ABCB,ABCC,ABCD,ABCE,ABCF

[Tinbendr]

Welcome to the board!

Please Login or Register  to view this content.

But you really don't need VBA to do this.

Please Login or Register  to view this content.

and copy down.