I have been assigned the task to take a spreadsheet from HR that will be generated weekly and plug the user information from the HR .xlxs spreadsheet into a .csv file, which will then be used to update users' info in AD. The column headings in the .csv file will be completely different than the one in the xlxs file. How can I just create that in excel? I believe that since this will be a repeated routine, that it could be achieved via macros and some VB customization. Please help. I have attached a sample of the excel file from HR and what the columns heading is supposed to be in the .csv file. What is needed is some way to formulate it in order to take the info from HR and put it in the .csv file with specific settings.
Bookmarks