Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-03-2015, 09:44 AM
lonniepoet lonniepoet is offline Filter Search Button Windows 7 32bit Filter Search Button Office 2013
Advanced Beginner
Filter Search Button
 
Join Date: Dec 2015
Location: Kansas City
Posts: 41
lonniepoet is on a distinguished road
Default 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!
Attached Files
File Type: xlsx 2016 test_NAT Reship Log.xlsx (13.9 KB, 9 views)
Reply With Quote
  #2  
Old 12-05-2015, 04:02 PM
charlesdh charlesdh is offline Filter Search Button Windows 7 32bit Filter Search Button Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

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.
Attached Files
File Type: xlsm 2016 test_NAT Reship Log.xlsm (22.9 KB, 11 views)
Reply With Quote
  #3  
Old 12-06-2015, 01:28 PM
charlesdh charlesdh is offline Filter Search Button Windows 7 32bit Filter Search Button Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 12-07-2015, 11:52 AM
charlesdh charlesdh is offline Filter Search Button Windows 7 32bit Filter Search Button Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

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.
Reply With Quote
  #5  
Old 12-08-2015, 10:09 PM
lonniepoet lonniepoet is offline Filter Search Button Windows 7 32bit Filter Search Button Office 2013
Advanced Beginner
Filter Search Button
 
Join Date: Dec 2015
Location: Kansas City
Posts: 41
lonniepoet is on a distinguished road
Default 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.
Reply With Quote
  #6  
Old 12-10-2015, 09:42 PM
excelledsoftware excelledsoftware is offline Filter Search Button Windows 10 Filter Search Button Office 2007
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

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.
Attached Files
File Type: xlsm 2016 test_NAT Reship Log.xlsm (24.5 KB, 13 views)
Reply With Quote
  #7  
Old 12-11-2015, 08:14 AM
lonniepoet lonniepoet is offline Filter Search Button Windows 7 32bit Filter Search Button Office 2013
Advanced Beginner
Filter Search Button
 
Join Date: Dec 2015
Location: Kansas City
Posts: 41
lonniepoet is on a distinguished road
Default

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.
Reply With Quote
  #8  
Old 12-11-2015, 10:58 AM
excelledsoftware excelledsoftware is offline Filter Search Button Windows 10 Filter Search Button Office 2007
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

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
Reply With Quote
  #9  
Old 12-11-2015, 11:01 AM
excelledsoftware excelledsoftware is offline Filter Search Button Windows 10 Filter Search Button Office 2007
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

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.
Reply With Quote
  #10  
Old 12-11-2015, 12:11 PM
charlesdh charlesdh is offline Filter Search Button Windows 7 32bit Filter Search Button Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

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.
Reply With Quote
  #11  
Old 12-11-2015, 01:10 PM
lonniepoet lonniepoet is offline Filter Search Button Windows 7 32bit Filter Search Button Office 2013
Advanced Beginner
Filter Search Button
 
Join Date: Dec 2015
Location: Kansas City
Posts: 41
lonniepoet is on a distinguished road
Default

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
Reply With Quote
  #12  
Old 12-12-2015, 12:00 PM
charlesdh charlesdh is offline Filter Search Button Windows 7 32bit Filter Search Button Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Red face

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.
Attached Files
File Type: xlsm 2016 test_NAT Reship Log-1.xlsm (33.1 KB, 11 views)
Reply With Quote
  #13  
Old 12-12-2015, 01:05 PM
excelledsoftware excelledsoftware is offline Filter Search Button Windows 10 Filter Search Button Office 2007
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

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?
Reply With Quote
  #14  
Old 12-12-2015, 01:26 PM
charlesdh charlesdh is offline Filter Search Button Windows 7 32bit Filter Search Button Office 2010 32bit
Expert
 
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default

Thanks for the complement.
I'll correct my copy. And let Lonnie correct his.
Attached Files
File Type: xlsm 2016 test_NAT Reship Log-1.xlsm (32.5 KB, 9 views)

Last edited by charlesdh; 12-12-2015 at 01:33 PM. Reason: Added corrected file
Reply With Quote
  #15  
Old 12-12-2015, 11:07 PM
lonniepoet lonniepoet is offline Filter Search Button Windows 7 32bit Filter Search Button Office 2013
Advanced Beginner
Filter Search Button
 
Join Date: Dec 2015
Location: Kansas City
Posts: 41
lonniepoet is on a distinguished road
Default

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...
Attached Files
File Type: xlsm Copy of 2016 test_NAT Reship Log-1.xlsm (33.5 KB, 7 views)
Reply With Quote
Reply

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft