Hello everyone.
If this is the wrong place to post a topic with this kind of question please move me to the right placeBut I think my issue is only solvable using some kind of programing which is above my knowledge.
Problem:
I have this report generated by a program (Shortel phone management) that shows all the calls for a given period. This report is output as an Excel spreadsheet.
The goal is to be able to see how many calls each person listed has made but the way the report is generated makes this very hard.
There is a bunch of information but only 2 columns have any importance.
If you look at the files I have attached "Excel Example" shows what these two columns come out looking like.
We get the name of a worker on the first column and the date and time of calls in the next column. There are other bits in there since this is not at all clean data but the important parts are the names and the number of calls.
What is currently being done by hand straight in Excel is copy and pasting to get the whole report looking like "Excel Example Result".
I can't think of any way to do this in Excel, but I keep thinking there has got to be a way to automate something with Access to look at the name and then cut and paste it into each row below until it hits the Sub Total below every one. I can import this into Access pretty easily and from there I have been trying to find some way to automatically copy past through the thousands of lines in this report.
Am I thinking straight? Is there any possible way to do this?
Thanks kindly for any input