yadavsaket1
New Member
Hey Experts,
I need a help regarding appending a set of data
E.g.
One folder has multiple files(xlsm) and multiple sheets
The internal structure of these sheets are same.
But I need only one common worksheet data and that with only A1:IX35000(in every workbook with different names but same name for sheet.)
I have tried to append in powerpivot but it is taking every data(after 35000 rows) which is unnecessary.
Any solution?
I need a help regarding appending a set of data
E.g.
One folder has multiple files(xlsm) and multiple sheets
The internal structure of these sheets are same.
But I need only one common worksheet data and that with only A1:IX35000(in every workbook with different names but same name for sheet.)
I have tried to append in powerpivot but it is taking every data(after 35000 rows) which is unnecessary.
Any solution?