Haiiiiiiiiiiiiii,
I have write a code for the advance filter and clear sheet option but the same is not working properly.
Test sheet is attached herewith...
Please help / suggest.
Haiiiiiiiiiiiiii,
I have write a code for the advance filter and clear sheet option but the same is not working properly.
Test sheet is attached herewith...
Please help / suggest.
Hi,
It would help us to understand your macro if you were to remove the VBA password
If you're wanting to filter all contractors, entry number and category then leave W6:Y6 blank
Since date number 60000 is 8th April 2064 you'll always return all dates so I'm not sure what you're expecting.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Sorry for the inconvenience... vba password removed.
Basically i want to filter between two dates and contractor wise.
Please help...
Hi surya2384
How does Sheet Data get populated? Is it imported Data? Can the Code modify it?
I'm thinking you don't wish to use Advanced Filter.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Data has been transferred from user form and I will like to apply filter with the help of advanced filter.
Does the attached help
Slightly modified macro. I prefer not to use reserved words
Please Login or Register to view this content.
Thanks a lot Mr. Richard Buttrey................ now it is working absolutely fine..............
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks