#1
|
|||
|
|||
Filter Search Button
I have am working on a log to catalog reshipments of orders. I was hoping to create a search bar that you could enter a value from the spreadsheet and it would only show you the rows of the items searched for. The most important values are the SKU#, Date Entered, Acct# BGCS Chain, & Store#. I tried using the method from a website found through Google (http://www.thespreadsheetguru.com/blog/2014/11/3/filtering-search-box), but I couldn’t get it to work correctly and it seemed a little convoluted. I know that this could easily be filtered and/or search through doing CTRL+F, but I am going to have a couple coworkers using this form and I wanted to make it simpler. I attached a copy of the spreadsheet I am working with and I am hoping to solve this issue before I have hundreds of reshipments before the New Year. Thanks in advance! |
#2
|
|||
|
|||
Hi,
This is only for test. When you open the file you can click the test button and select the "SKU" you can then click "Select" this will set a filter for the selected "SKU". It can be modified. |
#3
|
|||
|
|||
Hi,
I modified my code. But, I need more information. What do you want to filter on first? It will make a difference on what you want to see. |
#4
|
|||
|
|||
Hi,
You ask the same question at http://www.mrexcel.com/forum/excel-q...ch-button.html. You all so did not respond to my post with a sample. And, too you did not respond to my question. In doing so ( I might add that I have a working code as of now that may help) I will not post or answer any of your question now or in the future. |
#5
|
|||
|
|||
apology
Charles, I apologize for the cross posting. I am extremely new to forums and did not know this was an issue. Another user on another forum brought this up to me and I apologized there. I will not due this after this time. I thought that the reference on that forum was good enough. I understand your frustration. I didn’t respond back soon because I work 70+ hours a week and am not too experienced with forums. |
#6
|
|||
|
|||
This is a very good apology and I personally believe that everybody deserves a second chance. I do not want to be ostracized by this community but I feel that Lonnie just didn't know about cross posting. I certainly didn't when I was first using forms. I understand the large amount of hours working and can certainly empathize with that but a reply saying "Thanks I will check it out and get back to you" does not take a lot of time and can go a long way in the future for getting help.
Charles I really respect you and your abilities so I apologize if I over step but again I believe anyone especially someone who will publicly apologize should get a second chance. I have written my version of this solution and it is attached. This way people can see yours(Charles) and my solution that come across this post. Thanks everyone for understanding. |
#7
|
|||
|
|||
Thank you for understanding. Next time I will be more attentive to responses and make sure to communicate better. Balance is something I don't have time to work on.
I like this example. This works perfectly. I was wondering if it is possible to search for dates entered and account numbers too? Please let me know if this is possible. I would also like to learn how to do this coding better. If there are any instructions or tools available please let me know. |
#8
|
|||
|
|||
Lonnie, yes this is possible. I will need to update the code to do the Following.
Identify the date column Identify the account number column. Identify if the search string is meant for one of these columns Update the string to Work with the filter. Search that column and then exit. Should take about 15 mins when I get to it. Thanks |
#9
|
|||
|
|||
As far as learning and the amount of hours you are working you will need to find some time. The first step is to understand the basics
Variables if statements loops arrays etc. After that then you work out the logic and then practice practice. I will be happy to teach you just pm me your email. |
#10
|
|||
|
|||
lonnie and excelledsoftware
My apologies to you and yes we do need second chances. I was in the moment, and not thinking the out come. So, I do apologies for this. As far as over stepping not a big issue. Excelled your code is different than mine. I have a userform that allows the user to select the "SKU" this in turn set a filter for that "SKU" this action would then populate a "Combo" for the Dates and too populate a Combobox for the other categories that the user want to select that are associated with "SKU". I coded for "Non" duplicates" for each categories. Thanks one of the reason I wanted info from the user as to the "Selection" process the user would follow. If lonnie is satisfied your you approach that is Ok. But, in the mean time I'll finish my code and post it. I'll have it tomorrow. |
#11
|
|||
|
|||
I am glad to hear from you, Charles. I would like to compare your version against the current one and I should have time this weekend to log on and communicate all my concerns and give feedback. I am eager to work with everyone to help learn here. Thanks. -Lonnie
|
#12
|
|||
|
|||
Hi,
Here's my copy. I used a userform. When you open the file you can click "Test" a Form will show. You can the select from one od the combo box "Sku", "Date" and so forth. The box will not show duplicates. You can only make 1 selection when you make your selection you can click the "Select" button. The form will disappear and the selected filter will show the data. Warning you must as of now make only 1 selection. I can make it so that when the user make a selection they can not make another one. |
#13
|
|||
|
|||
Pretty snazzy Charles.
Looks like just the following line in the form code needs to be changed from ws.Range("A8:j8").Select to ws.Range("A7:j7").Select that way it will apply the filter on the header row instead of the first data row. I like this quite a bit its a great solution. Lonnie does this work for you? |
#14
|
|||
|
|||
Thanks for the complement.
I'll correct my copy. And let Lonnie correct his. Last edited by charlesdh; 12-12-2015 at 01:33 PM. Reason: Added corrected file |
#15
|
|||
|
|||
That is even better! This is exactly what I need. This will allow for the other users to access the information way easier. However, I was recently given another task by management to add and calculate data for each SKU# being entered. They would like me to calculate the percentage of mistakes (per specific mistake) for each one. I added the fields they'd like to track and the sheet they'd like in order to get their "program summary report." I know how to do all the simple calculations, but how to I get the program summary report to track a total for each reason per each SKU# and not pulls sums/totals of the other SKUs? Any help would be much appreciated. Let me know if I should open up a new forum or something since this is a different issue. It could be seen as an added issue I suppose...
|
Tags |
button, filter, search |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Onenote 2013 search is not identifying search terms correctly | Delta223 | OneNote | 0 | 08-12-2014 06:40 AM |
Search for date and then apply mutliple search criteria in huge dataset | maxtymo | Excel | 2 | 12-01-2013 04:52 AM |
Looking for Windows Search app with ability to search by content | gopher_everett | Office | 1 | 02-28-2013 09:23 PM |
Instant Search's "Display search results as I type when possible" with Exchange | lwc | Outlook | 0 | 06-01-2011 01:56 AM |
Search and Replace - Clear Search box | JostClan | Word | 1 | 05-04-2010 08:46 PM |