Hello!! Thanks for your solution. Your solution is very helpful.
Can this solution will be working fine if more files are added into folder. I want dynamic solution for it. I have some Employee Records Files data in column wise such as Employee_Name, Employee_ID, Employee_Age_Employee_Gender, Employee_Job_Role, Employee_Salary, Employee_Attendance, Employee_Job_Role, Employee_Job_Description in 3 excel files and One Master Excel file in which I have all these columns in row wise data.
I want to search these Employee Records files and match data with Master Excel file and add entries into Master Excel file accordingly. For example-: In Employee Records File Emp_Name it might be Name in another excel Records file. Accordingly search for Employee_Name and assign value in Master Employee Records File. The Employee Records files should be searched for those entries present in the Master Data File and Add Data accordingly in Actual Headers columns. I have added header name for Employee Records 1.
If any field is not present it will be blank in Master File. I want dynamic solution working for it. If there are more files added in directory. It should be working fine. All File Name such as ABC1 initial should be added into Masters Employee Records file. I am sharing you the Employee Records Excel file and Master Record Excel file. Please suggest proper solution for this issue as early as possible.
Also the challenge is that headers position in all Employee Records are not fixed. They are dynamic, Please help me out with this solution as early as possible.
ASFTAS_AQW_MOSIP_1212023230.xlsx (9.9 KB)
BBSDSDCD_2_1007223232.xlsx (8.9 KB)
DEEASAS_MQW_1612121212.xlsx (8.7 KB)
Master_Employee_Result_Header.xlsx (9.1 KB)