Hello Everyone,
I have 15-18 excel workbooks,
each workbook have a sheet named as ABC and all of these workbooks are present in a single folder.
No i want to combine or (append) all the data from all the workbooks (sheet-ABC) into a single file
problem is some files have let's say 30 columns some have 20 ,
data structure is not same.
how can i combine these files and how can i get data for each column in its position.
