Hi, I've been trying to figure this out for quite some time and its beyond me at this point. I've attached an example file below, thanks in advance!
My challenge is the basically to take the information from the master sheet and filter it out through a lease expiration sheet. The criteria that the information needs to be filtered by is Column "H" and "I" (possibly "J", but thats only if you want an extra challenge/see if it makes any sense to include). The "H" column has one of two values, "Start" or "Expiration". Essentially, what I want my lease expiration sheet to do, is to be able to have a Combobox that has filtering options for 6 months to 24 months from todays date and then have the formula you help me create filter the information from the master sheet to populate my lease expiration sheet with the correct rows. If a row in the master sheet includes "start" in column H, then I want to have the option to add 3 years or 5 years to the start date. I understand that would create duplicate information, but that can be dismissed when we review. The "expiration" tag will be very easy to code as it either falls within the range or it doesn't. One of my issues is getting a circular reference error FYI so that might be something that happens to you as well. Some of my attempts are included on the lease expiration sheet in the columns right of the labels.
Please hit me back with any questions if you're confused!
Helpsheet.xlsx
Bookmarks