Cheers got the attachment info.

Adding to List on daily basis
Wont be adding to this on a daily basis this is the full DCS alarm list.
What I would like is a daily task to be undertaken by an operator to take the DCS alarms from that day. Then paste it into this Master excel file (on Sheet 2) while Sheet1 contains all DCS alarms and then this will highlight (Red) which alarms have being initiated

Date Issue
When daily report is taken from DCS, this shows date and time at which alarm occurred this field could be added certainly

Priority
1 = High Priority
5 = Low Priority

Counter Issue
The use of a pivot table maybe

Thank you for your help so far bit new to system myself but this is generally what I would like but I am open to interpretation for other ways to do things looking to have this system as automated and fool proof as possible