snb

That is correct. I created the xlsm files by asking different questions to different people in this forum. I put together the ones that worked to get what I need. I do hardly know any VBA. When I first started this task was the first time I ever used VBA. When I was hired this was not part of the job description. When I was asked if it can be done I did get it to work in a timely manner. I knew it was not the best and most efficent way but In the end it does get me the correct formatted data so I am able to upload it into the accounting program and it is all correct in the end.

What takes me 3 hours a week has been able to remove 4 data entry employees by getting this to work. So my employer see what I have done as a great job.