Formula for copying a entire row based on a date range criteria.

**workallday** · 10-20-2012, 08:41 PM

Hello all,
I am creating a master tracker for my finance company and I am having a bit of trouble.

I have a "master list" that i am imputing all my information into. From that master list, I have a couple other sheets that are extracting data from it to create new spread sheets depending on the different criteria.

On the sheet that i am working on right now and having a bit of trouble with, my goal is to be able to extract a whole row into another sheet based on the Date of entry into the master list.

I have a column in the master spread sheet that is titled "Date of entry" and i want all the rows that are dated within a certain month to be extracted onto a new sheet.

Example: If the date of entry on one of the rows is 10/20/2012, then i want the whole row and all of its data extracted to a sheet called October 2012.

In the example below, I would want the whole row that says
Mike Jones - Steve Friedrich - 60 - 10.00% - 300,000.00 - 10/15/2012 - 10/20/2012 etc, to be extracted onto a new sheet labeled "October 2012" based on the entry that says 10/15/2012 under the "Entry Date" column, because that date entered is in October.

If anyone can help me i would greatly appreciate any comments or suggestions. Thank you!

Copy of Master Rep Tracker 2 Trail 10-20-12-1.jpg

**FDibbins** · 10-20-2012, 08:44 PM

please upload a sample workbook, not a picture. you might just get a picture of your solution sent back yo you

To Attach a File:

1. Click on Go Advanced
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.