I have a complex problem that I think only can be done with VBA, but I'm not idea how to do it. Maybe someone could help me.
I want to mark with "Selected" some given numbers that could be 1 or more. All begin with 5, but in order to mark the given numbers
the series that begin with 5 should be expanded.
For example, If I have only 3 numbers "to mark", these are 543, 5787, 59300, the output of numbers should consider all numbers
that begin with 5, adding "Selected" to those 3 given numbers.
The output would be:
I hope make sense
Thanks for any help.
I want to mark with "Selected" some given numbers that could be 1 or more. All begin with 5, but in order to mark the given numbers
the series that begin with 5 should be expanded.
For example, If I have only 3 numbers "to mark", these are 543, 5787, 59300, the output of numbers should consider all numbers
that begin with 5, adding "Selected" to those 3 given numbers.
The output would be:
Code:
50
51
52
53
540
541
542
543 "Selected"
544
545
546
547
548
549
55
56
570
571
572
573
574
575
576
577
5780
5781
5782
5783
5784
5785
5786
5787 "Selected"
5788
5789
579
58
59
58
590
591
592
59300 "Selected"
59301
59302
59303
59304
59305
59306
59307
59308
59309
5931
5932
5933
5934
5935
5936
5937
5938
5939
594
595
596
597
598
599
Thanks for any help.