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!

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!

I understand that, but what I would like it to do is automatically show data
for leases expiring for only 15 days out (pulling the date from the main
"rent roll" and copying it to a new sheet that says "leases expiring in the
next 15 days", I just started messing with a Pivot table and it is somewhat
what I am looking for.
Is there a way to edit the pivot table so that it isnt stretched out so far
horizontally, I would prefer it to have say 3 or 4 rows with the data in it
compared to 1 row with so many columns (I've never used a pivot table before).

Thank you!

"Sheeloo" wrote:

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!

One of the ways you can achieve this by recording a Macro for the following
steps

Filter for leases expiring in next 15 days
Copy the visible rows
Past them into new sheet

By assigning this to a button you can run this whenever you want...

"mobius9oo" wrote:

I understand that, but what I would like it to do is automatically show data
for leases expiring for only 15 days out (pulling the date from the main
"rent roll" and copying it to a new sheet that says "leases expiring in the
next 15 days", I just started messing with a Pivot table and it is somewhat
what I am looking for.
Is there a way to edit the pivot table so that it isnt stretched out so far
horizontally, I would prefer it to have say 3 or 4 rows with the data in it
compared to 1 row with so many columns (I've never used a pivot table before).

Thank you!

"Sheeloo" wrote:

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!