LinkBack URL
About LinkBacks
hi all,
I have a code filtering my database table by dates actually between two dates, but it's not workin with me
and i dont know WHY
please, anyone reviews that
the code in userform2
Please Login or Register to view this content.
hi all,
I have a code filtering my database table by dates actually between two dates, but it's not workin with me
and i dont know WHY
please, anyone reviews that
the code in userform2
Please Login or Register to view this content.
Last edited by Mamud; 03-09-2012 at 07:51 AM.
Up
Up
UP
criteria range is wrong
look here to see why
http://www.contextures.com/xladvfilter01.html
look at the bit filtering between dates your code should reflect this
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
sorry martindwilson, but i dont understand
did u mean the AND statement is wrong ?????
please kindly can u edit the attachment or mention the wrong line in code ??
You are trying to filter to a different sheet, it should be the same sheet
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
thx royUK
but it dosnt work also >>>>
Try using a Custom Filter
Please Login or Register to view this content.
hi roy
can i use Advancedfilter instead of autofilter ?
Hello Mamud,
Here is the code for the filter. You have have to filter the data twice.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
hi Leith
it really works.....
Thx Leith
Dear Leith,
I would like your help, as I am trying to creat a macro for searching between two dates usinng advanced filter, I have my data set as :
date/ inventory/ sales/ wages/ (those are the columns) so this would be the lis to be filtered , the name of the sheet is (production) and the list to be filtere is a10:G5000
CRITIRIA RANGE AND COPY TO WILL BE A SPOT ON THE SAME SHEET CALLED PRODUCTION
could you please helpe me create this code, as I was not able to search between two dates using advanced filter, eventhough my advanced filter setup was successful and it does the job very well except for searching between two dates, and the auto filter between dates did not do the job wanted for me eventhough it did work
many thanks in advance for your help
Mark
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks