Purushottam
New Member
I have 4 merged cells excel workbooks naming OUTPUT_8A , OUTPUT_8B , OUTPUT_8C AND OUTPUT_8D i want to combine these files into one excel workbook( required format attached) weekly please solve this problem
Combine 4 excel merged cells workbooks into one
- Thread starter Purushottam
- Start date
Purushottam
Did You try to modify Yourself Your previous thread?
Did You try to modify Yourself Your previous thread?
Extract data from merged multiple excel file to single excel file
I have more than 150 merged cells excel files naming Report, Report(1),Report(2)..etc. i want to extract data from these excel files to single excel file Both Report file and Sample file attached herewith.
chandoo.org
Purushottam
New Member
no this is new query
p45cal
Well-Known Member
In the attached, a Power Query offering which may not be very robust.
There's a cell at AA2 which is a named range FullPath. Enter here the full path to the folder.
The query only looks at .xls files whose name begins output (case insensitive) in that folder.
Right-click the table and choose Refresh.
Row 1 in the sheet is not necessary.
There's a cell at AA2 which is a named range FullPath. Enter here the full path to the folder.
The query only looks at .xls files whose name begins output (case insensitive) in that folder.
Right-click the table and choose Refresh.
Row 1 in the sheet is not necessary.
Purushottam
New Member
While adding a new excel file to this folder it showing error "Data could not be retrieved from the database." the new excel file is attached herewith.
Purushottam
New Member
Thanks sir your magic works
only 1st column consumer status is not repeating in below rows (each rows) like DISCONNECTED, PERMANENT DISCONNECTED,REGULAR
Thank u sir
Purushottam
New Member
Worked 100% Thank u so much