Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

select specific pair number

i have an list of numbers but need to pick an specific
for example

need show all numbers with 09 and show and new sheet same position
98765.xlsx
Avatar of aikimark
aikimark
Flag of United States of America image

need show all numbers with 09 and show and new sheet same position
I could use a little more detail or a workbook example with your sample data.  Finding/filtering values is common.  I don't understand your output/result requirement.
Avatar of ADRIANA P

ASKER

aikimark  thanks for the fas response

Sheet data  have the list
like this
User generated image
after i look for 09

it just keep on the numbers with 09  and that what i need

User generated image
So, you want to clear the contents of any cell that does not contain "09"?
aikimark  Yes !
In your example, there are non-empty cells that do not contain "09", such as 079, 019, and 039
aikimark

1- i have an list of numbers
2- then i need pick up just the number ( in this sample 09)
3- 09 can be any position of the number like ( 0x9, 09x, x09, 90x, 9x0, x90)

i need be keep in the same positon of the original data in
Are you always going to select two digits?  If not, how much variance?
aikimark
 in this situation  i always look for 2 digit
ASKER CERTIFIED SOLUTION
Avatar of aikimark
aikimark
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
aikimark  thanks

can you provide an sample  

im not an computer literacy

i  mean i don't know how use the code
1. Open the VBProject window (Alt+F11)
2. Insert a module in your workbook.
3. Copy/paste the code into the module
4. In the Developer ribbon, Run Macro
5. Select the name of the routine.
aikimark thanks

but

is not working
upload the workbook
Here is !
98765_A.xlsm
The routine was missing an End Sub statement.
ok but

Im  looking for an more complete solution
like for example

i need a input to enter the data i need look for
then an button to make the look for
Thanks ! Expert