| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a Range of column depending on the date | Excel Worksheet Functions | |||
| sheet protection - only selected range to be able to select/input data | Excel Worksheet Functions | |||
| select a range, copy it to a new sheet | Excel Discussion (Misc queries) | |||
| select date range in column | Excel Worksheet Functions | |||
| date criteria to select range | Excel Worksheet Functions | |||
Hybrid Mode
