S
Samantha
Hello,
Here is what I am trying to do.
I have 50+ worksheets within a single workbook.
I am trying to gather certain data, by date, that was inserted from each
worksheet. In total I will have 4 summary worksheets (by each quarter).
For example:
Let's say I only have 4 worksheets - 2 are input and 2 are summary.
In the input worksheet #1 I have:
Date Comments
01/26/09 aldjkfasdlfalj
02/09/09 kjafldkjf
03/31/09 lijierqe
04/15/09 sadfsdfoi
05/02/09 adfweqt
Input worksheet #2:
Date Comments
01/19/09 aldjkfasdlfalj
02/22/09 kjafldkjf
03/04/09 lijierqe
04/30/09 sadfsdfoi
05/15/09 adfweqt
In the first Summary Worksheet I want all information from the dates ranging
from: 01/01/09 - 03/31/09 and in the second Summary Worksheet I want all
information from the dates ranging from: 04/01/09 - 06/30/09.
How do I go about doing this?
Thank you so much,
Samantha
Here is what I am trying to do.
I have 50+ worksheets within a single workbook.
I am trying to gather certain data, by date, that was inserted from each
worksheet. In total I will have 4 summary worksheets (by each quarter).
For example:
Let's say I only have 4 worksheets - 2 are input and 2 are summary.
In the input worksheet #1 I have:
Date Comments
01/26/09 aldjkfasdlfalj
02/09/09 kjafldkjf
03/31/09 lijierqe
04/15/09 sadfsdfoi
05/02/09 adfweqt
Input worksheet #2:
Date Comments
01/19/09 aldjkfasdlfalj
02/22/09 kjafldkjf
03/04/09 lijierqe
04/30/09 sadfsdfoi
05/15/09 adfweqt
In the first Summary Worksheet I want all information from the dates ranging
from: 01/01/09 - 03/31/09 and in the second Summary Worksheet I want all
information from the dates ranging from: 04/01/09 - 06/30/09.
How do I go about doing this?
Thank you so much,
Samantha