Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Populate worksheet with data that meets date range criteria
Goal:
By entering a beginning date and an ending date on Sheet2, I hope to populate Sheet2 with data from Sheet1 within the selected date range below row 3 on Sheet2 and above a row of formulas to calculate column totals. Setup: Sheet1 €“ €˘ A5:A1058 has a list of dates in ascending order €˘ Columns B thru E have the dates respective total sales in dollars for each inventory item (e.g. B = Bottled Beer, C = Draft Beer, D = Liquor, and E = Wine/Champagne). Sheet2 €“ €˘ Designed as a printable report. €˘ Cell B2 = Beginning Report Date and D2 = Ending Report Date €˘ Cells B5:E5 are waiting for data to be copied down in row 4 to total (i.e. the formulas move just below the populated cells to give the column totals for the inserted data. I have tried a few suggestions from similar posts. However, none quite work the way I need it to. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
QUERY data range to populate separate worksheet? | Excel Worksheet Functions | |||
find date that meets a criteria | Excel Discussion (Misc queries) | |||
find date that meets a criteria | Excel Discussion (Misc queries) | |||
Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions |