View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Samantha Samantha is offline
external usenet poster
 
Posts: 24
Default Sharing data from one worksheet to another

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