ADRIANA P
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
for example
need show all numbers with 09 and show and new sheet same position
98765.xlsx
So, you want to clear the contents of any cell that does not contain "09"?
ASKER
aikimark Yes !
In your example, there are non-empty cells that do not contain "09", such as 079, 019, and 039
ASKER
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
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?
ASKER
aikimark
in this situation i always look for 2 digit
in this situation i always look for 2 digit
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
aikimark thanks
can you provide an sample
im not an computer literacy
i mean i don't know how use the code
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.
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.
ASKER
aikimark thanks
but
is not working
but
is not working
upload the workbook
ASKER
Here is !
98765_A.xlsm
98765_A.xlsm
The routine was missing an End Sub statement.
ASKER
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
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
ASKER
Thanks ! Expert