I have a EXCEL file w/ 3 fields: "Emp-Num", "Emp-Name", "City Coverage"
"City Coverage" has 1 to many names of cities covered by an employee. If more than 1 city, the cities are separated by a comma. I need to copy each record to another EXCEL file. If an employee covers more than city, then that record is copied N times; once for each city. The output file has an additional column; "City Total", which has the count of cities covered by the employee.
I am very familiar w/ VBA, but have not used VBA w/ EXCEL. Please help. Thank you, very much. Enclosed, is an EXCEL file w/ 2 tabs: "Original" shows the data. "Final" shows what the data needs to look like when completed.Test_Data1.xlsx