#1
|
|||
|
|||
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! Last edited by shaun0406; 11-15-2021 at 04:05 PM. Reason: More Info |
#2
|
||||
|
||||
Fill in any criteria in cells B3:G3 and click the update button.
|
#3
|
|||
|
|||
As an alternative, a way to do same without any coding.
Columns with couloured headers (helper columns) you can hide! |
#4
|
|||
|
|||
This works great. Thank You!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 new Table template based on existing table | Cadmiumcadamium | Word Tables | 1 | 08-14-2016 08:58 PM |
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 |