Hi Guy & Girls,
Have a current situation with an alarms list from DCS system at work output file is .CSV.
Each alarm has specific tag and all have priority ratings
What I would like is a template type WorkSheet with possibly some code/VBA where by when the alarms list in copied and pasted from DCS to excel file all high priority alarms are flagged i.e. cell turns red or something to that effect
Included is the worksheet:
The Tag Name is unique and does not appear anywhere else.
Element Number, Alarm Message, Priority, Action, Responsibility and Comments are not unique.
Not all alarms will occur in a daily process (i.e. maybe only 3000 and some may never alarm) thus what I need is a template type file, where by the alarms that occur on a specific date can be copied from the DCS into this file.
Once copied they will then flag each appropriate Tag Name and also if possible to have a counter for the amount of time an alarm has being processed.
Shown here is a link to Dropbox with the Excel file attached
https://www.dropbox.com/s/j52xnwt6fn...ll%20List.xlsx
Dont have much knowledge of VBA but would appreciate push in the right direction. Using Excel 2007 also
Thanks for your help in advance.
Have a current situation with an alarms list from DCS system at work output file is .CSV.
Each alarm has specific tag and all have priority ratings
What I would like is a template type WorkSheet with possibly some code/VBA where by when the alarms list in copied and pasted from DCS to excel file all high priority alarms are flagged i.e. cell turns red or something to that effect
Included is the worksheet:
The Tag Name is unique and does not appear anywhere else.
Element Number, Alarm Message, Priority, Action, Responsibility and Comments are not unique.
Not all alarms will occur in a daily process (i.e. maybe only 3000 and some may never alarm) thus what I need is a template type file, where by the alarms that occur on a specific date can be copied from the DCS into this file.
Once copied they will then flag each appropriate Tag Name and also if possible to have a counter for the amount of time an alarm has being processed.
Shown here is a link to Dropbox with the Excel file attached
https://www.dropbox.com/s/j52xnwt6fn...ll%20List.xlsx
Dont have much knowledge of VBA but would appreciate push in the right direction. Using Excel 2007 also
Thanks for your help in advance.
