At my work we use Excel to track our inventory for our stock metal sheets. The only thing about a record that changes is the quantity when we add/remove sheets. I am trying to limit searching through long tables by making a simple filter that will only show me the sheets based on criteria I provide using the filter function.
What I want to know is if there is any way that I can expose the records true location from the filtered result so I can edit the actual record quantity without having to manually go into the table and find it.