|First off, as soon as I see "many sheets" with "hundreds or thousands of lines of data" I begin to think that a database program would probably be better than an Excel workbook.|
Second, when I see "I know a little VBA" I lean even further towards a database program that already has these search features built in, along with many other features to help you keep track of your data.
Asking for code in a free help forum such as this may work out at the beginning, but if you can't maintain the code or adapt it to changes in your business model, then that could have an impact on your bottom line.
Finally, when I see this type of request, I am often only seeing the tip of the iceberg. "OK, thanks that does what I asked for. Now can you add this or make it do that?" In fact, in your first post you asked for a code that searched for data, but in your second post you asked that the code search for data within a cost range - an additional requirement was added before we even got started.
Added requirements can sometimes mean nothing more than an extra line or 2 of code. However, sometimes the additional requirements mean that the code should be entirely rewritten to avoid ending up with inefficient code with all sorts of bolt-ons that make the code hard to understand and maintain.
All that said, I'd be willing to give it a shot, but I can't get involved in a long term "add this, change that" type of situation.
Are the users entering the data manually or using drop downs?
I would think that drop downs would be the best way to go since that would eliminate data entry errors and ensure that they only entered data that would actually be found. I'm not saying that there must be $.05 Clowns in inventory at all times, but we don't want the users entering $.05 Clownz and thinking that there are no $.05 Clowns because they misspelled Clowns.
Finally, I would need Column and Row information before I could offer anything that we might expect to work - unless you just want some "generic" code that would show the process of how to choose the correct worksheet, then filter the criteria down so that the correct rows are returned.
One last question: Let's say the user searches for all data related to $.05 Clowns in Warehouse 1 and the data is returned Then the user searches for all data related $1.00 Elephants in Warehouse 3, should all the data related to the $.05 Clowns be cleared from the results sheet?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.