copy from multiple wbooks (with inconsistent headers & data) into one master wbook

dellzy

Board Regular
Joined
Apr 24, 2013
Messages
146
Hi All,


I have been trying to create a template that can allow user merge multiple worksheets from multiple workbooks into one master workbook. The content being copied into the master workbook should be based on the header pre-defined in at Row 1 (not case-sensitive).


I found on the net to merge wsheets and workbooks but it doesn't do validation check on the content before it merges. it just copy the whole range that content data as per column counted in that worksheet. This gives me the hassles because in the multiple sheets and wbooks have inconsistent arrangement of columns and I have to arrange all these first one by one first before I merge them.


Eg.
Master Workbook should have all data based on the headers below:-
Name | Age | Mobile# | Occupation | address | Gender


Workbook1 sheet 1 have data based on headers below:-
Name | Gender | Age | Address | Occupation | mobile


Workbook2 sheet 4 have data based on headers below:-
Name | Occupation


Workbook 3 sheet 1 have data based on headers below:-
name | age | mobile# | occupation | address | gender




I hope I have explained my problem clearly. Would appreciate your expertise to help.


Thank you in advance.


Best Regards,
DZ
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,213,495
Messages
6,113,992
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top