Advanced Filters – Cell Value Matching Another Cell

Hello! I am trying to do the following without VBA (if possible):

I want my data to filter based on whether or not one of the column’s value matches the value of another cell. For example, one column has a list of locations…say New York, California, Texas, Florida, etc. Another cell in the same workbook (lets call it Sheet2!A!5!) will contain one of these locations, and its value will change periodically. I want my data to filter automatically to contain only the cells whose locations match the location in the other cell (Sheet2!A!5!). I would also like the filtering to update when the location in cell Sheet2!A!5! is updated. Is this possible to do without VBA? I tried doing it using the Advanced Filter option, but I don’t seem to understand how to make a criteria range.

 

Thank you in advance for your help!

By: Tiffany

325 thoughts on “Advanced Filters – Cell Value Matching Another Cell

  1. Marvis Basemore

    There are definitely lots of particulars like that to take into consideration. That may be a great level to carry up. I offer the ideas above as basic inspiration however clearly there are questions just like the one you deliver up the place the most important thing shall be working in sincere good faith. I don?t know if finest practices have emerged around things like that, however I’m sure that your job is clearly recognized as a good game. Each boys and girls feel the impression of just a moment’s pleasure, for the rest of their lives.

  2. a325 tension control bolts

    Woah! I’m really loving the template/theme of this blog. It’s simple, yet effective. A lot of times it’s challenging to get that “perfect balance” between superb usability and appearance. I must say you’ve done a awesome job with this. Additionally, the blog loads very fast for me on Chrome. Superb Blog!

  3. superb maids llc

    I really like your blog.. very nice colors & theme. Did you make this website yourself or did you hire someone to do it for you? Plz answer back as I’m looking to construct my own blog and would like to find out where u got this from. kudos

  4. house cleaner las vegas

    Hey there! I realize this is sort of off-topic however I had to ask. Does managing a well-established blog like yours take a massive amount work? I am completely new to blogging but I do write in my diary daily. I’d like to start a blog so I will be able to share my experience and thoughts online. Please let me know if you have any ideas or tips for new aspiring bloggers. Appreciate it!

  5. house cleaner

    Hello there! This is kind of off topic but I need some help from an established blog. Is it very hard to set up your own blog? I’m not very techincal but I can figure things out pretty fast. I’m thinking about setting up my own but I’m not sure where to start. Do you have any tips or suggestions? With thanks

  6. flying with a medical condition

    Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my blog that automatically tweet my newest twitter updates. I’ve been looking for a plug-in like this for quite some time and was hoping maybe you would have some experience with something like this. Please let me know if you run into anything. I truly enjoy reading your blog and I look forward to your new updates.

  7. holiday vacations catalog

    Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your blog? My blog site is in the very same area of interest as yours and my visitors would certainly benefit from some of the information you present here. Please let me know if this alright with you. Regards!

  8. travel insurance policy

    Hello! I know this is kind of off topic but I was wondering if you knew where I could locate a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having difficulty finding one? Thanks a lot!

Comments are closed.