I’ve been struggling with this for a while now, maybe someone out there can help?
I have a tenancy schedule with data relating to tenants i.e name of tenant, lease start date, lease end date and rental.
I want to pick out all the tenants with lease start dates that fall within a date range that i will specify. For example my range is Jan 2010 to June 2011. I want to pick out all the tenants that have lease start dates falling within that range and output their “name”, “lease start date”, “lease end date” and “rental” into a separate worksheet. So basically copy the whole row into another worksheet if the lease start date falls within Jan 2010 – June 2010.
I have tried vlookups but that doesnt work if more than one lease has the same start date and falls within Jan 2010-June 2010. HAve also tried if statements but then i end up with a million nested ifs and it leaves spaces where tenant lease dates dont fall within my range.
Can anyone help? 🙁