Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Monthly Breakdown
Worksheet "Overall" list all my orders. I want to pull/copy all data to
another worksheet "Monthly Breakdown" when it meets a month/year date range (i.e. 2/2009, 3/2009). Sort of like below: Enter date range: 3/2009 (all data will display below this) WS5678 4567889 engine WS4678 4667999 transformer Etc. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Monthly Breakdown
Roy,
Just select your table and apply data filters, and on your date column, select the custom option, with Greater than or equal to Start Date, and Less than or equal to your End Date. HTH, Bernie MS Excel MVP "roy.okinawa" wrote in message ... Worksheet "Overall" list all my orders. I want to pull/copy all data to another worksheet "Monthly Breakdown" when it meets a month/year date range (i.e. 2/2009, 3/2009). Sort of like below: Enter date range: 3/2009 (all data will display below this) WS5678 4567889 engine WS4678 4667999 transformer Etc. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Monthly Breakdown
Not sure what you mean by "select your table." Is this from my "Overall"
worksheet or do I create it on a new worksheet? Here is what I use for getting totals, but need something that will display individual data: =SUMPRODUCT(--(TEXT(Overall!H8:H2002,"mmm/yyyy")=TEXT(I1,"mmm/yyyy")),Overall!AI8:AI2002) Thanks. "Bernie Deitrick" wrote: Roy, Just select your table and apply data filters, and on your date column, select the custom option, with Greater than or equal to Start Date, and Less than or equal to your End Date. HTH, Bernie MS Excel MVP "roy.okinawa" wrote in message ... Worksheet "Overall" list all my orders. I want to pull/copy all data to another worksheet "Monthly Breakdown" when it meets a month/year date range (i.e. 2/2009, 3/2009). Sort of like below: Enter date range: 3/2009 (all data will display below this) WS5678 4567889 engine WS4678 4667999 transformer Etc. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Monthly Budget Breakdown | Excel Discussion (Misc queries) | |||
Breakdown | Excel Worksheet Functions | |||
How do I set up monthly random work schedule for 60 hours monthly | Excel Discussion (Misc queries) | |||
How 2 breakdown $$$ into $ $ $? | Excel Discussion (Misc queries) | |||
Mortgage template comparing interest pd, monthly, bi-monthly, ext. | Excel Discussion (Misc queries) |