Ok, I don't 100% understand this part: "Find method with xlPart in VBA code."
What I meant by "Find feature in Excel" was the find menu. I didn't know about Find function.
I quickly tried this, but got a Value error: =FIND("iphone 4 crystal screen",C2:C10000)
Could you let me know how to use...
OK, for example, a row in a worksheet(product_list) to create reference table(SKUprice) looks like this:
Camera ABC00001 ABC SONY a55 Front Screen Protector [Crystal Clear] $1.99
The reference table, "SKUprice" has SKU on the far left, product name, and price. (ABC00001 is SKU, and "ABC...
Hi, Skip. Thanks for your reply. There are couple problems, though.
1. Actual product name is painfully longer. For example, the actual name of the one that I wrote could be "ABC iphone 4 ultra crystal clear front screen protector set" something like this..
2. There is already the reference...
Hi. This has given me a headache since yesterday when one of my suppliers required to use their own order from that I have to search an SKU number from the list of 1000 items in several worksheets.
I need to set up a quick way to search multiple words in Microsoft Excel to make this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.