Transferring CERTAIN Data from one worksheet to another

  • Thread starter Thread starter Samantha
  • Start date Start date
S

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!
 
Back
Top