Creating a Search Command Button (Macro)

[pinkgold]

Hi Guys,
I am computer literate, however my knowledge of excel is limited, so bear with me. I am trying to create a uniform stock database for my company. Thus far, I have 2 worksheets. The first is a face sheet, for the user to interact with. This face sheet has a number of drop down menus on it allowing them to select "Type" and "Size" of the item they need. This information is then translated (by a hidden table) into an item code.
The second sheet contains a list of all the uniform items currently in stock. Each item has its individual code that correlates to the code the face sheet generates.
My question is regarding a search macro.
I want the user to be able to click a command button on the face sheet, labelled "search". This would then take the generated "Item Code" and search for it on the second worksheet. I am aware that it would be very easy for them to simply copy the code into "find" on the second sheet, however it needs to be as easy and quick to use as possible.
Any help would be greatly appreciated. Thanks[/SIZE][/SIZE][/SIZE]

[royUK]

An example workbook would help

[pinkgold]

Thanks for the reply mate. I have attached an example sheet.

What im looking for is a macro that copies the item code from the first sheet and searchs for that code on the second sheet.

Thanks for the help

[royUK]

Why do you need a macro/ You could use VLOOKUP?

[pinkgold]

I could use VLookup if i knew what that was, if you could implement Vlookup into that sheet i would be able to work it out.

Is it really hard?

Thanks

[royUK]

VLOOKUP is fine, but I really should point out to you and others - explore Excel's built in features before venturing into VBA.

Read up on VLOOKUP - this should help http://www.excel-it.com/excel_functions.htm

[pinkgold]

Thanks for all your help mate

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved and rate the answer.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[[email protected]]

My first post here sorry if Im not following the rules. I have created a userform in excel where user's enter a range of data (name and vehicle information). I have set this up where each entry is assigned a number. Is there a way I can create a userform where users can enter either the number or name to show the results of the data (if it's in there) if not msbox "no data found". Thanks in advance for help on this topic.

[arlu1201]

kconti,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.