Results 1 to 6 of 6

Thread: Filter and Search Button

  1. #1

    Filter and Search Button



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 (The Spreadsheet Guru Blog - 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 Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    a pivot table is what you need - in the attached, play with the filters on each of the fields, re-arrange the fields, show hide subtotals/grand totals, move the pivot table to another sheet etc. etc.
    Attached Files Attached Files

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    Oh groan, you've cross posted without supplying links.
    Read the rules, they're the same on all forums.
    http://www.mrexcel.com/forum/excel-q...ch-button.html
    http://www.excelforum.com/excel-prog...ch-button.html

    lonniepoet, for your information, you should always provide links to your cross posts.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

  4. #4
    I apologize for the cross posts. I had no idea all the forums were linked like that. I like the pivot table, but I was really hoping for a box I could type a SKU# into and hit a search button and automatically have the spreadsheet only show that SKU#. I understand that I could do a simple sort/filter, but I would like the spreadsheet to have this option instead. I was toying around with some of the codes and buttons from one of the other cross posts, but I just canít get the darn thing to work. See attached and any help would be much appreciated.
    Attached Files Attached Files

  5. #5
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    In the attached, on sheet1, cell B1 there's a drop down which when you click shows a list of items to choose from, but at the very top is a search box where you can start typing your SKU number and the list will diminish - you can then use the down/up arrows (if you want) then press Enter.
    It's just a bog standard pivot table. No code/vba/macros.
    Attached Files Attached Files
    Last edited by p45cal; 2015-12-05 at 12:49 PM.

  6. #6
    Acolyte Charles's Avatar
    Join Date
    Feb 2013
    Location
    Biloxi
    Posts
    34
    Articles
    0
    This member also poset at http://www.msofficeforums.com/excel-...ch-button.html
    Where I replied but did not receive a response.
    Perhaps this member should read the forum rules at all of the sites he posted too!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •