Consolidate data to master file

**pradyumnajpn10** · 05-18-2017, 03:51 AM

Hello Guys,

Being a novice I tried my best but with vain no result.
Any help would be really appreciated.

By clicking a Macro Execute button in Master file
1. Prompts to clear previous Data (Yes/No).If we click No it should append to the previous data or else Clear all only Heading should remain.
2. Import data from several Input file(attached) from folder at once. File and Folder names are in Japanese characters.
3. Export the data from Input file to Master file and save.
No need to create any separate folder for exporting.

Attaching the Input file Template,
should extract data from sheet1 and sheet2(no need to extract data from 3 rd sheet), apart from the heading which is in blue color.

Need to process these types similar departmental files and import to master file.
Note:Since The file names are in Japanese character it is not showing properly in the attachment.

Rgds,
Prady

**JBeaucaire** · 05-20-2017, 10:47 AM

'WORKBOOKS TO 1 SHEET STACKED
Here's a macro for collecting data from all files in a specific folder.

Workbooks to 1 Sheet

The parts of the code that need to be edited are colored to draw your attention.
There is some additional code at the bottom you can add in to cycle through multiple sheets.

'WORKBOOKS W/MULTIPLE SHEETS MERGED INTO SHEETS IN CONSOLIDATION WORKBOOK
Here's a macro for collecting data from all sheets in all files in a specific folder merging into matching sheets.

Workbooks to Sheets - Part 4

The parts of the code that need to be edited are colored to draw your attention.