PDA

View Full Version : combine workbooks with same column count



b1c11ap
09-12-2012, 03:34 AM
Help Needed;

I have different workbooks in .csv format. these are opened one-by-one using a code.

all the workbooks have only one worksheet (always).

the columns in all workbooks may be different. say there are 6 workbooks with 388 columns, 5 with 184, 3 with 233, etc. (these column numbers are examples only)

i wish to combine workbooks with same number of columns in a single workbook.

for this example, there will be 3 new workbooks.

would appreciate any help.

thanks