Select data to appear on 2nd sheet by date range...
 

I have a range of dates and a range of corresponding numbers. i would like
to select from the data on sheet one by date range, then show the selections
on subsequesnt sheets.

The sheets are fiscal year dates (i.e. greater than 6/31/07 and less than
7/1/08) and the numbers are currency amounts. I would like the entire line
of data, including dates and amounts, to show on the 2nd sheet (FY 07-08).
Then I can SUM the amounts to determine costs for that particular fiscal year.