Macro to create new workbook for each column

Registration date
Wednesday October 31, 2012
Last seen
October 31, 2012
- Oct 31, 2012 at 09:20 PM
Hi All,

I would like to ask for your very kind help to the below query.

I have a big excel files say containing 100 + 1 extra columns. I want to seperate these 100 columns into 100 new workbook (each will contain one column + the extra 1 column, so each workbook will have 2 columns)

so workbook1 will have column A + column ZZ(at column A and column B), workbook2 will have column B + ZZ(at column A and column B)

and also want to name the new workbooks with incremental name. workbook1 = XXXX1, workbook2 = XXXX2 and so on.

Really appreciated for your great help!!!