filter by date

I have a single, large (about 17K lines) data export from a database which populates about a dozen pivot tables. Most of these are primarily filtered by a "Required Date" column, which changes daily. I need to select the current date and all dates in the past, which up until now has involved a...

Hi everyone, I'm using vba to filter a series of Pivottables on different worksheets within the same workbook. Most of these Pt's don't really form a problem. However for my reports i want to be able to set the YTD months (in reportfilter) to the same month i'm defining in NewCat 1, 2 or 3...

hi guys can anyone help me in figuring out how to insert filter in access 2007 reports based on start date n end date ???? i am stuck in this please help me

Hi I have this Code, that i would like to shorten Because it's long and slow?. Some of the line is recorded with the "record macro" function. The pivottables pulls data from an OLAP Cube! Can anyone help? Sub RunAll() 'Kører følgende makro'er Call Makro1 Call Makro2 Call...

Hello everyone, I have a macro which I want to filter data by date, every field that is not today or yesterday, however when I run this, it doesn't return anything in the filter so I think it is not recognising the criteria as a date. Any ideas on how to resolve this? Many thanks Dim myDate...

I currently have a task managing spreadsheet that is organized by approaching deadline (upcoming deadlines appear first on the list in order of when they are due). I want to create a dropdown menu at the top of the spreadsheet with options "2015, 2014, 2013, etc" so that I can easily see...

Newer Excel programs (I am using 2013) have very useful filters. I would like to know how to access the current filter setting's StartDate and EndDate in vba code.(Sorry for cross posting in SO but its not likely to get anywhere after almost a month of having been asked) So there are a bunch of...

Hi I have a pivot table report that uses a dynamic range as its source, the data is continually growing with new data sets added each day into the data table. To update the pivot I have added a Macro button which refreshes the pivot table, however as new dates are added each day the Value...

In VBA coding is there a way to select the last two dates on a filter on a pivot table. These two dates will change every week so they need to be date variables. Lightamir

Hi All I am trying write code to filter for all data before today's date which is contained in a cell. I assumed that it would be pretty basic and that filtering using the "<" symbol would work. It works for standard numbers, but dates don't seem to like it. The filter determines that there...

Hi Guys, I think I have a bit of a challenge for some VBA guru out there? So I hope someone can help? I have a listbox filtered with one criteria, looking for all the Listitems that have a certain Style Number which is handled by "strFind2", all works well. What I need is to filter the listbox...

Hi, Please see the attached spreadsheet image. Column B to I has one row per record, Column J onward each record has additional data in the additional rows. For example if you see in attach image, a record in row3 (John, Hernandez), the record is associated with row 3 to row11 but Column...

I have a growing log of sales activity where each row contains a Sales Stage, a $$ value, a sales rep name, and a date of creation. Each time a sale is progressed to the next stage, a workflow adds another row to the log containing. I want my reporting tool to create a history of "How much $$$...

Hello everyone, it's my first time here, I have two time series spreadsheets with different dates. My goal is to create one spreadsheet with a common column of dates. I would like to alter/filter sheet 1 so that the date column matches the date column of sheet 2. Once i can do this i can...