I have a large excel file, 5000 Rows Sample of it is uploadenter link description here
the file contains data about employees as following: First Column: Employee Name Second: Employee ID Columns 3-7: Experiences (Multiline Values) 3: Career Name 4: Rank 5: From 6: To 7: Reason For Leaving Columns 8-13: Managerial Jobs Columns 14-17: Education Columns 18-26: Courses
Now each employee will have many multi line values for Experiences, Managerial Jobs, Education and Courses, in other words, he have many courses one at each line on the same row
Now what is needed is as following: Excel Macro (VBA): 1. To Move every employee (Row) with the header to a new worksheet in this same workbook, and name the sheet with employee ID which is located in Column 2 (The Code of this is read)
- For Each multi line value (Education For Example), it should add each line in a separate row
- If Possible Sort every multiline values by date, from older to newer. and thats it,
In the attached excel file, I've made the first employee, it is it possible to repeat this operation for about 5000 employees, if not, what database do you suggest to use, can Microsoft Access do it?
Aucun commentaire:
Enregistrer un commentaire