selfishways
New Member
- Joined
- Feb 21, 2011
- Messages
- 1
Hi
I'm looking for some direction on solving a problem that I am having. I recognize that I am asking for help in my first post and as a member of various forums I recognize this can be frowned upon, so my apologies.
In my job, I am generating a report each day. The report is saved automatically with the date and time that it was generated in the file name. The report is an excel file in .xls format.
The report is basically a table in excel, which shows "calls" raised by clients. Each "call" has its own row in the report, with a unique number which identifies the call.
What I want to be able to do is generate a list of calls that have appeared in the previous 5 days reports. Since my knowledge of excel and VBA is fairly basic; im struggling with where to start.
One issue currently floating round my head are:
-The reports are generated at different times each day, the solution will therefore need to only look at the date in which the report was created.
Any guidance will be greatly appreciated. I am happy to provide further information/background as neccesary; however I don't want to overload the thread with unneccesary details.
Thanks
Paul
I'm looking for some direction on solving a problem that I am having. I recognize that I am asking for help in my first post and as a member of various forums I recognize this can be frowned upon, so my apologies.
In my job, I am generating a report each day. The report is saved automatically with the date and time that it was generated in the file name. The report is an excel file in .xls format.
The report is basically a table in excel, which shows "calls" raised by clients. Each "call" has its own row in the report, with a unique number which identifies the call.
What I want to be able to do is generate a list of calls that have appeared in the previous 5 days reports. Since my knowledge of excel and VBA is fairly basic; im struggling with where to start.
One issue currently floating round my head are:
-The reports are generated at different times each day, the solution will therefore need to only look at the date in which the report was created.
Any guidance will be greatly appreciated. I am happy to provide further information/background as neccesary; however I don't want to overload the thread with unneccesary details.
Thanks
Paul
