I need your help on this as im having a hard time trying to get this to work.
here is an example of what im trying to do.
in the excell sheet I have data in Column C this data looks like this
14-18-22-28-32.
it always reads from left to right, smallest to largest.
this data I have is large, about 10,000 cells of this data type and keeps growing.
now the data I have is the same type of Data as the
14-18-22-28-32 delimited, in the range; column E1 to AM9276.
so I would select a cell in column
C and run a search of at least 3 matching contents of the
14-18-22-28-32, and at the same 4 matching contents of the
14-18-22-28-32 and lastly the 5 matching contents of the
14-18-22-28-32, the macro would look at the selected Combination in column C and look for all matching contents in the range of E1 to AM9276 and if the matches are found within the range from E1 to AM9276 those would be highlighted.
this model below is to show what type of searches regarding what numbers it is looking for in regards to the position or rather where the number are found in the combination
14-18-22-28-32.
so the macro would look for all matching and partial matches in the range E1 to AM9276.
So I need a macro to be able to have the below model run when I select the combination in Column C then highlight the matching in the range E1 to AM 9276.
The model is just for easier understanding on the criteria how it looks for the duplicates of the data in Column C which are found in the Range E1 to AM9276.
so the data below with the numbers
14-18-22-28-32 will be used on where to look for the matching numbers. so for example the first number of the search will look through the entire range of data in E1 to AM 9276 for all the matches to 14-18-22-28, then it will go to the next one and search for the data 14-18-22-*-32, if course the Star"*" isnt there but the macro is built so it knows which numbers within the combination to look for meaning the 14-18-22-32. the macro will continue untill of the these are done all 13 of these below.
1-2-3-4-* |
14-18-22-28-* |
1-2-3-*-5 |
14-18-22-*-32 |
1-2-*-4-5 |
14-18-*-28-32 |
1-*-3-4-5 |
14-*-22-28-32 |
*-2-3-4-5 |
*-18-22-28-32 |
1-2-3-*-* |
14-18-22-*-* |
1-2-*-4-* |
14-18-*-28-* |
1-*-3-4-* |
14-*-22-28-* |
*-2-3-4-* |
*-18-22-28-* |
1-2-*-*-5 |
14-18-*-*-32 |
*-*-3-4-5 |
*-*-22-28-32 |
1-*-*-4-5 |
14-*-*-28-32 |
1-2-3-4-5 |
14-18-22-28-32 |
|
|