I'm not sure exactly what the best approach is for this, but I'll do my best to explain what I'm looking for accomplish and I also attached an example with some notes within the workbook too.
Each worksheet (tab 1-30 & 31-60 in the attached) will have 30 "sets" for specific data entry. For example tab "1-30" the first set are rows 12-31, set 2 is rows 35-54, etc.
Each "set" will contain 3 data points. A "group", "ID#" & "type"
A "group" will be a numeric value in the format of 1-1, 1-2, 2-1, 2-2, etc. A "group" number will be entered in multiple "sets"
An "ID#" is a numeric value related to the group. for example group 1-1 will have ID#'s 1-1-1,1-1-2,1-1-3, etc.
Each "ID#" will have 2 types. Either "+" or "-". for example 1-1-1 +, 1-1-1 -
At the end of the data entry each ID# should have both types.
The goal is that i want to make sure there are no duplicate "ID" values with the same "type" value within the entire workbook. For example there cannot be (2) 1-1-1 +, 1-1-1 +
I'm thinking I need a macro to scan for duplicates and maybe highlight the "ID#" cells RED if it contains a duplicate. The ideal thing would be once you enter a duplicate ID# & Type the cell would automatically turn RED or a message box could appear.
So in the attached example I'll hopefully further explain the above.
in worksheet 1-30
Set 1 = rows 12-31
the "group" numbers are in column I
the "ID#"s are in multiple columns: O, W, AE, AM, AU, BC, etc.
the "types" are in multiple columns next to the ID#'s: Q, Y, AG, etc.
Cells O19/Q19 & W21/Y21 both contain the ID/type of 1-1-1+ (which is a problem).
I hope this isn't too confusing, I tried my best to simplify the basics of the data entry. Any help is much appreciated, even just a suggestion on the best approach to accomplish this would be helpful.
Thank you!
Bookmarks