Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-15-2021, 03:59 PM
shaun0406 shaun0406 is offline Creating a search table Windows 10 Creating a search table Office 2010
Novice
Creating a search table
 
Join Date: Dec 2020
Posts: 19
shaun0406 is on a distinguished road
Default Creating a search table

Hi!



I am trying to create a field where I type a specific criteria and then it shows all rows with the matched criteria to a column

I have attached with my excel file.

I tried looking up guides and instructions online but I am stumped

I am using EXCEL 2010

Thank You!
Attached Files
File Type: xlsx StoreList.xlsx (39.7 KB, 8 views)

Last edited by shaun0406; 11-15-2021 at 04:05 PM. Reason: More Info
Reply With Quote
  #2  
Old 11-15-2021, 04:48 PM
p45cal's Avatar
p45cal p45cal is offline Creating a search table Windows 10 Creating a search table Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Fill in any criteria in cells B3:G3 and click the update button.
Attached Files
File Type: xlsm msofficeforums47988StoreList.xlsm (47.8 KB, 10 views)
Reply With Quote
  #3  
Old 11-16-2021, 06:02 AM
ArviLaanemets ArviLaanemets is offline Creating a search table Windows 8 Creating a search table Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

As an alternative, a way to do same without any coding.

Columns with couloured headers (helper columns) you can hide!
Attached Files
File Type: xlsx StoreList.xlsx (102.3 KB, 12 views)
Reply With Quote
  #4  
Old 11-22-2021, 04:21 PM
shaun0406 shaun0406 is offline Creating a search table Windows 10 Creating a search table Office 2010
Novice
Creating a search table
 
Join Date: Dec 2020
Posts: 19
shaun0406 is on a distinguished road
Default

This works great. Thank You!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a search table Help creating VBA code to search multiple word documents for specific group of words dmreno Word VBA 3 07-30-2019 02:31 PM
Creating a Table of Contents in a table format Ellymoo Word 9 06-22-2017 08:15 AM
Creating a search table Creating a new Table template based on existing table Cadmiumcadamium Word Tables 1 08-14-2016 08:58 PM
Creating a search table VBA Table – Search All Tables - Find & Replace Text in Table Cell With Specific Background Color jc491 Word VBA 8 09-30-2015 06:10 AM
[OL2010] Creating a search folder with folders belonging to other POP3 Account balubeto Outlook 0 01-07-2011 02:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:04 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