Creating a search method in an excel sheet to identify things according to a specific id.

Hello everybody!
I am very new to VBA programing . Basically I am a Mechanical Engineer. I have been assigned a project wherein I have to create a search engine for the database I have created. The search should be based upon the text . Also I want all of this to look aesthetically good and want the columns to be separated out into boxes when a search is done.
Any help would be very appreciated.
Thank you

Just confirm what do you mean by the word "Database"?

Yes surely we can do it...

Please attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

No issue we wait for it

Hello Moh13,


Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)


You could consider using something like - "Create Search Engine Form Excel Spreadsheet Data" or what ever you may feel would be more appropriate.

Thanks for changing the Thread title

Refer the attached file for Non VBA solution

can you make the cell where we write the material number look like a blank ?...and also can there be a choice like 'reset choice' so that the written matter in the material entry cell/blank automatically clears...?
Also I was thinking if the sheet 1 can be a welcome sheet..having company logo and all..but with the material choice blank..that would look nice..
and if i can get a button or something so that when we press it it gives the complete stock of everything that we have...i plan to shift the data base to sheet 2 or 3..plz help

Hello Moh13,

Please see the attached Workbook.

I have made the changes for you, as per the revised attached sample Workbook.

Hello Moh13,


If you are satisfied with the solution given to you, then please mark your Thread as Solved.

Thank you.

Regards

Hello Moh13,

Please try it now. I have Created a named Range called MatNumbers, based on the Data in Column B of Sheet 1, for the DropDown on the Main Sheet.

To see what the Code looks like, that activates Sheet 2, when you enter a number on the Main Sheet, right-click on the Tab of the Main Sheet, and then select view Code.

Hope that helps!

Hello Moh13,

You are welcome.


If you are satisfied with the solution, then please do mark your Thread as Solved.

Thank you.

Regards

Hello Moh13,

See Sheet3 of the attached sample Workbook, for the answer.

Regards

Hello Moh13,

O.K. I have changed things a little bit for you, and hopefully the attached Workbook would be more to your liking.

Regards

Hi Moh13,

..but can you tell me what did you do..

The changes to your previous Workbook, took me more than an hour, and to now eplain everything in detail, will require far too much time.

In short. Unhide Rows 6 and 7 on Sheet1, and there you will see the formulas. All the Cells in Row 6 have been formatted to Number, with two decimal points. Column A, automatically inserts a Ser. No. as soon as Data is enterd into Column B. Check the Formulas down Column A, and while in one of those cells, also check the Data Validation, which "Locks" and cancels any attempted entry.

I have deleted the Shapes Rectangles, and replaced it with standard Excel worksheet formats, formulas and so on.

Compare the two Workbooks, and pick up the differences from there.

Regards