Excel 2007 : Link worksheet to another worksheet

[vest78]

Ok I'm going to do the best that I can to describe what I need to do.....

I am in sales. I have to do my own lead books.... aka put all my contacts information into an excel file. I physically cold call buildings and insert names, addresses and expiration dates into the excel file. What i want to do is transfer the tenants that are less than X number of days out from their expiration date to another sheet that I will label as my immmediate call sheet. Can somebody please help me?

[davesexcel]

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.