I am trying to create a macro that will filter data between certain dates.
This date range is determined by the user selected report stage and end dates in column H.
What I want to happen is when the user enters the report start and end dates - in this case 01/02/2012 to 28/02/2012 - the table (columns A to E is filtered for this date range.
See attached file.
Hi try this
p.s. change the place of end data (cells h2) into first row becouse the sorting could hide the row with this value.
Please Login or Register to view this content.
Last edited by tom1977; 06-01-2012 at 06:11 AM.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Originally Posted by tom1977
Hi try this
p.s. change the place of end data (cells h2) into first row becouse the sorting could hide the row with this value.Please Login or Register to view this content.
Tom,
i have tried this, it hides all of my data except for row1.
For me it works (look into attachment)
Last edited by tom1977; 06-01-2012 at 08:52 AM.
Very strange. When I run the macro in you attached file I get this.
Please check again my attachment (probably I have uploaded not correct one.)
No sorry, it iis not working for me.
Are You sure that the format of date in cells H1 and H2 is in correct format?
or
the date You typed in was in range?
Last edited by tom1977; 06-01-2012 at 09:23 AM.
I believe so, I have just opened your attached file and run the macro?
So I do not have idea. Sorry. When I open this it works...
Hi Excel_Monkey,
As pointed out by Tom, I would check to ensure your dates are indeed dates.
To check a date, use =ISNUMBER(Cell Reference)
If it is a date, the answer is TRUE, if not, FALSE
If you find out they are not dates and just showing as dates but really text, highlight the column of dates, Data Tab >> Text to Columns >> Next >> Next >> Date MDY (or DMY) >> Finish.
HTH
Regards, Jeff
change
toPlease Login or Register to view this content.
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Hi Excel Monkey,
Have you ever worked with Advanced Filters? They do what I think you are looking for. See http://www.contextures.com/xladvfilter01.html and look down the page to Advanced Filter Criteria Examples.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
That Works! Wow, thank you, this has been driving me mad.change
toPlease Login or Register to view this content.
Please Login or Register to view this content.
Marvin, I shall also look into the advanced filters.
Sorry to bother you, but why "Value2" and not "Value"?
value2 returns the date as a Double not a date data type which can be misinterpreted when used as a string
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks