I have a spreadsheet with a column ("E") calculating aging based on the current date and the date an item was submitted, calculated in weeks, for all rows. I want to add a pushbutton control where the user selects a range (drop-down list in cell E4) and then pushes the button to filter the list. I have never used ranges in vba so I am lost.
For example, one option in cell E4 would be anything open for more than 1 week but less than 3 weeks, with a status of "Open" (status is in column "H"). ALso, I need to include any row in "E" that has an "X" (for the subheading rows for each section). I can't figure out how to do this. I have some coding started (but can't copy it here. my Work computer does not allow access to this site and can't send the code out of my work email either).
I just I am looking for some language for the criteria range. For the option I mentioned above, anything with a 1, 2, 3, or X in column E would remain after the filtering, as long as column H = Open.
I appreciate any help on how to do this. Apologies for not being able to post the coding I have so far.