Hello all,
I have a main file that gather information from 2 other files and needs to be updated every Monday.
All files have the same structure (seen below) and I need a macro that will check the rows for the incident number from the slave files and determine if the status is different in the master. If it is, then needs to change the columns next to it. If the the incident does not exist in the master then it needs to create a new row at the bottom of the master file with the new information.
columns on the master file:
[TABLE="width: 1338"]
<tbody>[TR]
[TD]TICKETKEY[/TD]
[TD]STATUS[/TD]
[TD]ASSIGNEDGROUP[/TD]
[TD]ASSIGNEDTO[/TD]
[TD]TYPE[/TD]
[TD]ARRIVALDATE[/TD]
[TD]RESOLVEDDATE[/TD]
[TD]PRIORITY[/TD]
[TD]TICKETTYPE[/TD]
[TD]SUMMARY[/TD]
[TD]ORGANIZATION[/TD]
[TD]SLABREACHREASON[/TD]
[TD]PRODUCTNAME[/TD]
[/TR]
[TR]
[TD]INC########[/TD]
[TD]Closed[/TD]
[TD]Apps-test test[/TD]
[TD]User name[/TD]
[TD]Not Found - Action Needed[/TD]
[TD]2017-01-02 14:03:39[/TD]
[TD]2017-01-02 14:03:45[/TD]
[TD]Medium[/TD]
[TD]incident[/TD]
[TD]test test test[/TD]
[TD]example 1[/TD]
[TD]Not Tagged[/TD]
[TD]product 1[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance.
I have a main file that gather information from 2 other files and needs to be updated every Monday.
All files have the same structure (seen below) and I need a macro that will check the rows for the incident number from the slave files and determine if the status is different in the master. If it is, then needs to change the columns next to it. If the the incident does not exist in the master then it needs to create a new row at the bottom of the master file with the new information.
columns on the master file:
[TABLE="width: 1338"]
<tbody>[TR]
[TD]TICKETKEY[/TD]
[TD]STATUS[/TD]
[TD]ASSIGNEDGROUP[/TD]
[TD]ASSIGNEDTO[/TD]
[TD]TYPE[/TD]
[TD]ARRIVALDATE[/TD]
[TD]RESOLVEDDATE[/TD]
[TD]PRIORITY[/TD]
[TD]TICKETTYPE[/TD]
[TD]SUMMARY[/TD]
[TD]ORGANIZATION[/TD]
[TD]SLABREACHREASON[/TD]
[TD]PRODUCTNAME[/TD]
[/TR]
[TR]
[TD]INC########[/TD]
[TD]Closed[/TD]
[TD]Apps-test test[/TD]
[TD]User name[/TD]
[TD]Not Found - Action Needed[/TD]
[TD]2017-01-02 14:03:39[/TD]
[TD]2017-01-02 14:03:45[/TD]
[TD]Medium[/TD]
[TD]incident[/TD]
[TD]test test test[/TD]
[TD]example 1[/TD]
[TD]Not Tagged[/TD]
[TD]product 1[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance.
Last edited: