Find a website URL in a cost sheet

[kassan]

Hi all

so, I have this person I deal with, He send me cost sheets as the one I attached
in the left column "item" there is the item number, embedded in it a particular website
which is clickable
if you right click on it and choose edit you can clearly see it
the main website is always the same
page.auctions.yahoo.co.jp/jp/auction/

what interest me is the final extension
for instance, items 526 and 527
page.auctions.yahoo.co.jp/jp/auction/v643373016
page.auctions.yahoo.co.jp/jp/auction/q317663141

I got nearly a thousand of items and need to put some order
so what I need is a way to use the search function to find, for example extension "v643373016"
if I use the usual ctrl+F nothing will be returned of course
but there must a way to find those extension

really hope you can help me
thanks in advance

[vba_php]

not sure why the find feature doesn't work for you with regard to what you are trying to do. perhaps you are setting the wrong options? I simulated it and it worked just find for me using the same type of data strings and search criteria:

[kassan]

thanks
but still it doesn't work
I tried every possible options combo in the search window
but this is what I always get

[vba_php]

in the image you are trying to find s689503978. but that number is not found anywhere in your image. are you sure it is in your sheet? if it is, post an image of where it's at. thanks. I don't believe the fact that you are using excel 2003 or earlier has anything to do with it. this feature you are using was created from the beginning. version 1 of excel.

[kassan]

thanks a lot

that is embedded into item 528
if you right click on 528 and choose "edit hyperlink" you will find the url
page.auctions.yahoo.co.jp/jp/auction/s689503978

I attached 2 pics
of course I am sure I am just making a fool of myself but I am indeed totally lost

[vba_php]

of course I am sure I am just making a fool of myself but I am indeed totally lost

you're NOT a fool, but I will admit that you are a little lost. LOL. the feature you are trying to use finds VALUES, my friend. you are searching for a string that's in a HYPERLINK. that is not a value. the only way you can do this, that I know of, is use code. like this:

Please Login or Register  to view this content.

let it be known that there is no such thing as a dumb question. but there is such a thing as a dumb repeat asking of a question. Ask Ali, she knows that I do it all the time.

[kassan]

you're NOT a fool

I think you are now going to change your mind about that
the thing is I never ran a code before
I spent a few hours doing some searching, I swear, i didn't want to come back here again begging
but I failed again
I was looking here for example
datanumen.com/blogs/how-to-run-vba-code-in-your-excel
but it didn't work
I get an error message like the one in the pic
so yeah I could use a little more explanation, only when you have a spare 5 minutes

[vba_php]

LOL. you put the value whatever into your code! OK OK, I'm not going to make fun of you. I know you're just starting out. Don't worry about it. here, let me help....

=> say you are searching range for the string s689503978 INSIDE of a hyperlink like your image shows. and say you want to search one column, ok? cells A1 - A10. then the code would be this, in the most simplistic sense, considering that you enter s689503978 into the input box:

Please Login or Register  to view this content.

now I know you don't follow that, but the only thing you really need to learn is how to loop a range in the easiest manner possible. like this, taken from the above code:

Please Login or Register  to view this content.

images below:

image 1
the simulated values I used to do the work for you, and to test on.

image 2
the code that produced the result

image 3
the input box that the code pops up and the value I searched for

image 4
the result of the code's return

so.....can you run with it now? keep in mind that the values behind the hyperlinks. (e.g. - the hyperlink ADDRESSES themselves are actually the values located in column ''B'' in this example of mine. this is the essentially the same thing that you are doing.

what else I used:

https://docs.microsoft.com/en-us/off...nge.hyperlinks

https://docs.microsoft.com/en-us/off...cel.hyperlinks

https://docs.microsoft.com/en-us/off...yperlinks.item

[kassan]

heh..

well, to be fair (to myself) I did try with putting cell numbers
you can look at attached pictures, however I got a different error message, as you can see
also, the first line "Sub sample()" turned yellow

I will try again, carefully looking at your pics
and report back

really appreciate what you are doing

[vba_php]

you got the error message because you put the word:

Please Login or Register  to view this content.

into the statement, instead of what it should be:

Please Login or Register  to view this content.

oops! no wonder the compiler thinks its undefined! cuz it is!