• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search item code no from item master dataset

JAMIR

JAMIR

Member
Hello, Good Morning everybody..

I have 1000 Automobiles spares which is codefied. Now i am search item description with the entered of code number with vlookup formula.

My problem is when the customer give indent he give description of the items not item code number and then i have find the correct code Number of the said item.

Is there any VBA code solution for gives search list for entered word.

for example there is 5 type of bearings in my dataset. When I hit the Bear [Bearing] it show the list of 5 Bearing list. Then I select the appropriate item from the list and it give the code number realated to selected item. It is possible with the VBA Code

Regards,

Zameer Shaikh
 

Attachments

  • Item Search.xlsx
    10.1 KB · Views: 11
Dear Zameer Shaikh:

I am not sure I have understood your question correctly.

You can use Advance filter option to filter the information of the item description. You can use wildcard "*" in the query.

In the attached sheet G:K is query fields and in J2 I have entered the customer's description with "*" as "*ring 6*, You have to run the advance filter by selecting your data set, entering G1:K2 in your query field. The result will give you all recording which contains the characters "ring 6" in the item description. Here the result will throw two row of records (row 1 & 2 of the data set) - that is records for this two items.

Bearing 6208
Bearing 6305

Hope this helps.
 

Attachments

  • Item Search.xlsx
    10.3 KB · Views: 7
Hi Zameer ,

I have just copied the form and the code from another file which I had created in reply to a question. See if it helps.

You need to run the macro Sheet1.Show_Userform.

Narayan
 

Attachments

  • Item Search.xlsm
    17.3 KB · Views: 18
Hello Narayank991 Sir,

Glad to see your reply. Sir, i see you attached file, you have created userform, but i want as you see my file in the colomn "Description of item" if i start to type Bear, Dropdown list generate and show the type text releated item list which is recall from the Dataset Sheet.

Sir, my english is very poor. Sorry if you getting problem to understand my query. I just want the specific item code no. & Part No. by typing the text.

Regards,

Zameer Shaikh
 
Ahmed said:
Dear Zameer Shaikh:

I am not sure I have understood your question correctly.

You can use Advance filter option to filter the information of the item description. You can use wildcard "*" in the query.

In the attached sheet G:K is query fields and in J2 I have entered the customer's description with "*" as "*ring 6*, You have to run the advance filter by selecting your data set, entering G1:K2 in your query field. The result will give you all recording which contains the characters "ring 6" in the item description. Here the result will throw two row of records (row 1 & 2 of the data set) - that is records for this two items.

Bearing 6208
Bearing 6305

Hope this helps.
Click to expand...

Assalam-o-allaikum Ahmad Bhai,

Thank for your reply. But brother my query is different. It wont work.

Thanks once again for efforts.

Regards,

Zameer Shaikh
 
NARAYANK991 said:
Hi Zameer ,

Did you run the macro , and start typing in the textbox on the left side ?

Narayan
Click to expand...
Yes Sir,

I have run the macro and start the typing in left. It work first class, but in userform. I want list generate when i am typing in the "Description of Item" colomn.

It is possible Sir?

Regards,


Zameer Shaikh
 
Hi Zameer ,

Doing the same in a worksheet cell is , in my opinion , not possible , but I may be wrong.

If the basic purpose of your workbook is just to retrieve data , then it is better if the user is shown a userform , where data is entered and displayed. Allowing a user to directly interact with data , especially master data is not advisable.

If you can specify what exactly is the objective of this workbook , something can be worked out.

Narayan
 
Hello Sir,

I only want that, for the items Code Number & Part Number searching manually from the 1000+ items. Its very taking time & harrassment.
As you show me userform, i think it would be good userfull. I think there is give search buttom for macro, it will generate userform for searching the item. After type the specific text its show the list and if i click the specific item it should display the Code No. & Part No. releated to selected item.

It is possible Sir? If yes please advise VBA code to generate the itemsearch list userform.

Warmly Regards,

Zameer Shaikh
 
Hi Zameer ,

Certainly it is possible ; please give me a day or two ; hopefully I can upload the file tomorrow , since it is late tonight.

Narayan
 
Hello Narayank991 Sir,

Good afternoon! you are really awesome. Sir, check it. But i only want when the userform generate and after type in textbox list is displayed releated to type text. when i click the item it should be displayed the Code No. & Part No. on the userform. Not goes in Item_description cell. Thats it.

Can you make some changes Sir? Also I fill glad if you give your contact no. [as i have language problem], so i can contact you. if you dont mind?

Warm Regards,

Zameer Shaikh
+91 98509466662
 
Hi Zameer ,

Give me some time ; as I understand you , once you select a particular item from the list which is displayed , the corresponding code number and part number should be displayed in the userform itself. Is this correct ?

Narayan
 
Hi Jamir,

I have little similar to you query check this out.

Regards
Abdul Matheen
 

Attachments

  • Item SearchV1.xlsm
    22.8 KB · Views: 19
Good Morning Narayan Sir,

Now You are my idol hero... [GURU]. You really great heart person. As i saw you have listen very carefully what i want and fulfill my demand. Really you are awesome... I as give my number, i will appriciates if you give your number.

Sir, there is little bit query.. As i select the particular item its goes to cell d3, which i dont want. How it will stop?

Please do needfull....

Warm Regards,


Zameer Shaikh
+91 98 50 94 66 62
 
Hello Narayan Sir,

As i uderstand you have call the Code Number / Part Number and Unit Rate not from Dataset. Its called from Item sheet and after selection of item it goes to cell d3 then by formula Code Number / Part Number and Unit Rate recall on userform from item sheet. Right Sir.

It will helpful if corresponding Code Number / Part Number and Unit Rate are called from dataset. And selected item not goes in Cell D3.

Sir, i am waiting for your reply.

Warm Regards,

Zameer
 
Abdul Matheen said:
Hi Jamir,

I have little similar to you query check this out.

Regards
Abdul Matheen
Click to expand...


Hello Matheen Bhai,

I see your file. Its works great as per my requirement, but there is little bit of problem with combobox, which i need to search the item from dataset, there is 1000+ items and i can not search the items with scoll down instead of type the text.

But you really give great idea, i definatally use this in any other workbook. As Narayan Sir suggested userform, i appriciates and its fullfil my demand.

Finally, thanks a lot for giving such valuable response. Please keep in touch.


Salam,

Zameer Shaikh.
 
Hi Jamir,

You can type the text in the Combobox it will list down the data. Like you said you want to type only "BEAR" then all the beariing related list should come, it is same.Just type what the type you want in combobox you will get the list and base on the selection it will give you you the code.


Regards
Abdul Matheen
 
Hello Narayan Sir,

You are great Sir.

I think we need coffee.... what you say... Your Date & Your Time :)

Please always be with me...:)

Warm Regards,


Zameer
 
Abdul Matheen said:
Hi Jamir,

You can type the text in the Combobox it will list down the data. Like you said you want to type only "BEAR" then all the beariing related list should come, it is same.Just type what the type you want in combobox you will get the list and base on the selection it will give you you the code.


Regards
Abdul Matheen
Click to expand...

Hi Bhai,

Its really useful.

Regards,

Zameer
 
You must log in or register to reply here.
Back
Top