I have a report that's received as a .txt file. I recorded a macro to open the file as space delimited. The report has multiple pages and contains the employee name at the top of each page. I want to add a step to my initial macro that will copy their name for each day they had sales. The number of days for each associate can vary each week so I need to be able to identify a range for the number of days they have on the report and copy their name for each row. 

In the example I need Johns name to be copied on each row for dates 4/1 through 4/5, Debbie's name for the days she had sales, Mary for the days she had sales. 

How can I accomplish this?

[![Sales Report](https://i.stack.imgur.com/vkKa2.jpg)](https://i.stack.imgur.com/vkKa2.jpg)