I have a workbook that contains data for multiple thousands of employees in multiple countries. I need to separate that data into individual workbooks that contain just the rows for the employees that correspond to each country (So a “USA” workbook for all USA employees, an “India” workbook for all India employees, etc.) In the end, if I have employees in 20 countries, I need to have saved 20 separate workbooks.
I’ve opened my workbook, and logically I believe I need to (First) retrieve the value from the country column, (second) if no workbook exists for that country, create one, add the headers and row of data, and save it with the name of the country, (third) if the workbook does already exist, append the row to the existing workbook
I am having a hard time finding the right actions to do this in my loop.