Pulling Data that falls within a specific date range?
Requirement is very clear, what I don't understand is the reason for having a
separate sheet. You can filter on the existing sheet...
But if you insist on a new sheet then you can enter
=Sheet1!A1 in A1 of sheet2 (assuming your data sheet is named Sheet1)
Then copy this to cover all the rows and columns of your data and the filter
:-)
"mobius9oo" wrote:
I work with a small property management company, and we use Excel to track
where people are living as well as well as lease dates (when they start and
when they end)
What I would like to achieve, is to create another worksheet within the same
file that will show me whos lease is ending within the next 15 days from the
current date. I need it to show me the same information that I have in my
normal "rent roll".
To clarify things, I need an auto-populated list of all data associated with
dates that fall within 15 days!
My Lease End date is in column F on the tab "RENT ROLL"
I need all data in the rows that match =today() and 15 days out.
I don't know how clear this is, I'm hoping someone may understand!
|