Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Creating a search table Creating a search table
Register FAQ

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, 10 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: 947
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Fill in any criteria in cells B3:G3 and click the update button.
Attached Files
File Type: xlsm msofficeforums47988StoreList.xlsm (47.8 KB, 12 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: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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, 14 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

« Previous Thread | Next Thread »


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 06:13 PM.

Contact Us - Privacy Statement - Top

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