Search box for multiple sheets?

[Swifty2727]

Hey! First time poster and certainly not an Excel expert so I'm hoping someone who is can help me!

I was tasked with creating a database to store locations of stock in our stock room at work, I managed to do this with a line of search code but had the break it up into different days for the code to work, I was wondering if there was a way to make a search box separately that would search all of the sheets created? I've attached a monthly completed sheet and the master copy im using (again you will be able to tell i'm not excel expert )

Any help would be much appreciated, i've tried looking for solutions myself and am at a loss!

Kind regards
Scott

[LokeshKumar]

Hey,
Will revert you soon......

[sktneer]

Hi Scott,
Welcome to the Forum.

Here is a VBA solution to your problem. See if this helps.
After downloading the file, enable the macro when prompted.
Input the search number in the yellow cell and it will give you the output in adjacent columns.
The code used is for worksheet change event. you may view the code by right clicking the Search Tab --> View code.
The code will look for the number entered in the search cell in all the worksheets.

[Tony Valko]

Will revert you soon......

What does that mean?

[LokeshKumar]

What does that mean?

Hey I just opened the attachments but was running out of time..and it was half done..........
sorry for that one.......

[Swifty2727]

Thank you so much Sktneer! Its exactly what I was after, I'm glad there are people with so much expertise willing to help out like this

Again, cant thank you enough, Scott

[sktneer]

You're welcome. Glad to help.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.