I want help, I want work excel sheet that work on the search for a value according to the specific condition of the inserted values.EX: That i want insert some data like
From --------------- to ----------- Status
23801000------- 23801999------- non covered/close
22701000------- 22701999------- non covered/close
33712000------- 33712999------- non covered/close
ect...
any number start with 26,27 and 38 it's status will "non covered/close"
if any other number outside this inserted data it's status will "covered/open"
EX:if i will search for 23801770, this # that located between 23801000 23801999
the required status will be non covered/close
i want make VBA for search that if my number will located between these values Show me the status,So that i can increase the inserted data those values that are searched for the values required
Please i appreciate your effort if you upload excel sheet that contain the required solution
ThanQ,
From --------------- to ----------- Status
23801000------- 23801999------- non covered/close
22701000------- 22701999------- non covered/close
33712000------- 33712999------- non covered/close
ect...
any number start with 26,27 and 38 it's status will "non covered/close"
if any other number outside this inserted data it's status will "covered/open"
EX:if i will search for 23801770, this # that located between 23801000 23801999
the required status will be non covered/close
i want make VBA for search that if my number will located between these values Show me the status,So that i can increase the inserted data those values that are searched for the values required
Please i appreciate your effort if you upload excel sheet that contain the required solution
ThanQ,