Insert new rows and copy text macro help

Hello,

I have the attached my workbook Book1.xls and I am having trouble getting a macro to work where there are multiple locations for an employee. It needs to create a new row for each location, move that location number to the new row and delete it out of the old row. It then needs to copy the trained and employee number down to the newly created row.

The end result basically needs needs to have the employee number and trained column copied to each row and have the location be on its own row.

Hopefully that makes sense. Any help or suggestions would be greatly appreciated.

Thanks.

Hello b50,

You need to post a workbook that contains before and after examples of the data. If you have a macro written, please include it in the new post.

Hello b50,

This macro will transpose the data on the "Before" sheet. The results are copied over to the "After" sheet. This has been added to the attached workbook.

Please Login or Register  to view this content.