View Single Post
 
Old 12-03-2015, 09:44 AM
lonniepoet lonniepoet is offline Windows 7 32bit Office 2013
Advanced Beginner
 
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