Description
This file will allow you to compile all daily issues (incidents, problems, outages, major incidents, etc.) reported in excel occurring during the month in your company. By 1 click, the compilation will be created automatically and it will extract the result in 1 single excel file in xlsx format.
For instance, every day, you are doing a report about P1 issues and all your files are name as “daily_Year-Month-Day” (for example “daily_2019-01-19”). At the end of the month, you would haveabout 20 excel files,with this tool, by 1 click, it will compile all of them into 1 single one.
This product contains an access file with macros. The file has:
The macros will execute those following actions:
This 1 click macro tool can be used for any types of daily/monthly/yearly issues, it can be incidents, problems, outages, major incidents, etc. You may be interested by this bundle, read 1 click macro tool: create daily reports and compile them in 1 to create the monthly report in excel.
Requirement
Microsoft Access minimum version for Windows 7 to open the access macro file.
Basic knowledge of VBA coding macro. You may need to edit the macro to adapt this tool to your need. Comments are available in the macro to help but you will need a minimum basic knowledge of VBA coding macro.
Installation
All files should be in the same folder.
The tool is zipped so you will need to unzip it with the Microsoft Zip tool installed by default in your Microsoft Windows, read how to zip and unzip files in the Microsoft support website.
If the macro option is turned off in your Microsoft Access program, you have to turn it on, read enable or disable macros in Office files in the Microsoft support website.
To edit the macro, read Use a command button to start an action or a series of actions in the Microsoft support website
Support
A 7 days free support to adapt this tool that includes only:
It doesn’t include:
Feel free to contact me at itmet@itmanagementetools.com to improve this tool based on your need:
Samples | Access/Excel files without macros/formulas to download | Intranet issue webpage to see |
Price | 1.00 euros |
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...