I want to create a tool that is able to extract a specific sheet, e.g. "corporate", from a number of different Excel files, and consolidate it into one Excel file. Currently I am uploading the Excels from a folder on my local Desktop.
Thanks so much, super helpful! One more question - right now, the same row is being copied each time there is a new file - even though that row only has to be there once at the top of the sheet. Is there a way to remove the extra duplicates?
I've tried a lot of macros that consolidate sheets into one, however, i do not see any "Sheet name" column in the result window at the end of the workflow. Only the filename column. Is there a way to integrate this in your last macro? i have one workbook only and there are 4 sheet inside the workbook. I want a sheet name column for all the captured details. Thank you in advance.
I am trying to do the same; however, my worksheets have different names and schemas. My output is to one file with a template sheet with headers. I was hoping to add records from all (27) files/sheet combos to the template based on header name. Should any of the 27 table have an additional header, it will be dropped/null. Thanks for the help.
hi @binuacs , quick question, will it be possible in this workflow to reflect or retain the filename (not the full path), aside from the sheet name? or do i need to have a separate macros for that to reflect the filenames.
