Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter a pivot table in a macro
Hi,
I download a spreadsheet every week, with one of the fields being a date. I need to take out only the dates between the current day & 3 months later. When I do a macro, it just won't let me filter the pivottable. How can I do this ? Thanks for your help ! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter a pivot table in a macro
Jean-Marc,
Do you have a Pivot Table or a database? Describe the structure of whichever you have, and we'll go from there. HTH, Bernie MS Excel MVP "Jean-Marc P" wrote in message ... Hi, I download a spreadsheet every week, with one of the fields being a date. I need to take out only the dates between the current day & 3 months later. When I do a macro, it just won't let me filter the pivottable. How can I do this ? Thanks for your help ! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter a pivot table in a macro
I import a .txt file (separated with ","). There a 3 columns that I'm
interested in: "Part number","Required Date" & "Required quantity". I need the minimum quantity required for each part, so I created a pivot table with, on the left: Req.Date, on top: Part Number & in the middle: min Qty Required. NOw when I download that file, i get the info for the 6 previous months plus the next year. I only want to show the next 3 months in my pivot table. How can I do this ? Even if I sort the data that I get, when I update the pivot table, the non-desired dates are still shown. Thanks again ! Jean-Marc "Bernie Deitrick" wrote: Jean-Marc, Do you have a Pivot Table or a database? Describe the structure of whichever you have, and we'll go from there. HTH, Bernie MS Excel MVP "Jean-Marc P" wrote in message ... Hi, I download a spreadsheet every week, with one of the fields being a date. I need to take out only the dates between the current day & 3 months later. When I do a macro, it just won't let me filter the pivottable. How can I do this ? Thanks for your help ! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter a pivot table in a macro
Hi
Perhaps you could group dates by Month and Day, making the earliest date the first date you require, and the latest date 3 months later. Exclude the results for date < and Greater tan the relevant dates, and only select the Months. -- Regards Roger Govier "Jean-Marc P" wrote in message ... I import a .txt file (separated with ","). There a 3 columns that I'm interested in: "Part number","Required Date" & "Required quantity". I need the minimum quantity required for each part, so I created a pivot table with, on the left: Req.Date, on top: Part Number & in the middle: min Qty Required. NOw when I download that file, i get the info for the 6 previous months plus the next year. I only want to show the next 3 months in my pivot table. How can I do this ? Even if I sort the data that I get, when I update the pivot table, the non-desired dates are still shown. Thanks again ! Jean-Marc "Bernie Deitrick" wrote: Jean-Marc, Do you have a Pivot Table or a database? Describe the structure of whichever you have, and we'll go from there. HTH, Bernie MS Excel MVP "Jean-Marc P" wrote in message ... Hi, I download a spreadsheet every week, with one of the fields being a date. I need to take out only the dates between the current day & 3 months later. When I do a macro, it just won't let me filter the pivottable. How can I do this ? Thanks for your help ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table - Filter - no filter by value | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
parameter and macro driven pivot table filter? | Excel Programming |