Hello Excel Experts: I am mystified by how I created the attached file. It is a worksheet containing the physical layout of my fruit orchard. When a cell is clicked on, a filter directly below the layout responds with rows corresponding to the position of the tree(cell). I wrote this several months ago and it works. While it is saved as an xlsm, I don't see any macros involved. I cannot figure out how it translates the cell location into the position on the list. Is there a hidden formula? If so, where is it? Thanks!
Filtered List based on cell location
- Thread starter cgh0001
- Start date
Hi cgh0001, and welcome to the forum.
You're using a worksheet_selectionChange event, which is stored in a sheet module.
View attachment 28319
Luke: You are a super sleuth. Drink is on the house! Thanks, Chuck