First off would like to say that everyone here is very helpful. You have given me a lot of help and for that I am truely greatful.
I wish I could do this my self but it seems as if I have lost one to many brain cells.
I have a report that I do compile every week. This report 6 columns
A - Date/Time
B - Error Type
C - IP Address
D - DNS Name
E - Error Message
There is approx 30 differant Error Type (column B).
What I was looking for is a way to:
1. Copy each Error Type to it's own worksheet
1A. Name this work sheet with Error Type Name
1B. Add a column F - count how many times an ip address has a cetian type of error type,
1C Delete row IF ip address count is above 1, (so if ip address 10.10.10.10 has a UNIX error tyoe 4 times column F will show 4 but only one row of data will be on workbook)
Bookmarks