Transferring CERTAIN Data from one worksheet to another

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing data from one worksheet to another 0
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Data Summary Automation Help!!! 2
sum over a date range 7
Sum value between two dates and copy to new cell 7
IF ARRAY with multiple conditions. 1
//time calculations 4
Copy value according to date 1

Top