Transferring CERTAIN Data from one worksheet to another

[Samantha]

Hello,

This is what I’m trying to do:

I have 50+ worksheets within a single workbook.
I am trying to gather specific data, by dates, and separate them by putting
them into certain workbooks.

That doesn’t sound confusing at all, so I’ll put in an example:

I have 4 worksheets. Two are summary worksheets and two are input worksheets.

In the input worksheet #1 I have:

Date: Comments:
01/22/09 adflajd
02/24/09 ;lkfj;aoidg
03/09/09 ;alkdjfai
04/02/09 ioutiwetwe
04/30/09 v,cmvijoi
05/03/09 aietori

In the input worksheet #2 I have:

Date: Comments:
01/29/09 adflajd
02/02/09 ;lkfj;aoidg
03/14/09 ;alkdjfai
04/11/09 ioutiwetwe
04/23/09 v,cmvijoi
05/07/09 aietori

In the first summary worksheet I want all information ranging from the
dates: 01/01/09 to 03/31/09 and in the second summary worksheet I want all
information ranging from the dates: 04/01/09 to 06/30/09.

Thank a LOT!

 

[Herbert Seidenberg]

Excel 2007
Consolidate selected columns of Tables
in multiple sheets.
Advanced Filter with Macro.
No formulas.
http://www.mediafire.com/file/yt3zykojend/05_07_09.xlsm