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

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

  1. 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!

  2. 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!

  3. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *