estatefinds
01-01-2017, 10:34 PM
so the (event code) works on numerical data as it is written;
when I select the data in the column A, the macro will highlight the Matching data within the uncolored data in the range H5 to L35. So for example the A1 is selected the macro highlight the A1 that is found within the uncolored data, yellow, then when moved down to the next data in column A, I select the B1 and the A1 in the range H5 to L 35 will turn uncolored and now the B1 will turn yellow and so on.
Also the data range may be longer, for example H5 to L70 at times.
I need this macro to be restructured to work with the Alpha numeric data, Please!!!
I am attaching file
when I select the data in the column A, the macro will highlight the Matching data within the uncolored data in the range H5 to L35. So for example the A1 is selected the macro highlight the A1 that is found within the uncolored data, yellow, then when moved down to the next data in column A, I select the B1 and the A1 in the range H5 to L 35 will turn uncolored and now the B1 will turn yellow and so on.
Also the data range may be longer, for example H5 to L70 at times.
I need this macro to be restructured to work with the Alpha numeric data, Please!!!
I am attaching file