12-03-2015, 09:44 AM
|
Advanced Beginner
|
|
Join Date: Dec 2015
Location: Kansas City
Posts: 41
|
|
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!
|