Hello friends,
I have birthdates in column 'p'. I want to filter a birthday of persons today. I used the filter-today but it's not working as per my requirement. It filters only todays date which I don't want. To find the birthday today we have to ignore the year and filter the dates by dd mm format only. Likewise I also want to create a filter for tomorrow, week, month.
Please suggest me a trick for it.
Thanking you in anticipation.
Sincerely,
Mukesh
Just have a helper column to show only the DD MMM alone
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you but I need a vba code to perform this in a single click. The vba code should extract the day and month and then filter is my requirement because there are other programmes in my file in which the column and cell addresses are fixed.
Thank you.
Mukesh
Can this file help you?
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Dear popipipo,
Excellent creation! It's not my requirement. I want to filter the persons whose birthday is today. No matter what is his/her age. I have nothing to do with year.
Please see my file. I have other programmes in it which I don't want to disturb. Suggest me a method/vba code to achieve the target without disturbing the file format.
Thank you for assistance.
Regards,
Mukesh
Hello Mukesh,
Use Advanced Filter:
Leave B1 empty, then in B2,
=TEXT(TODAY(),"ddmm")=TEXT($P9,"ddmm")
Select data B8:AD20, go to Data >> Advanced Filter,
List Range: $B$8:$AD$20
Criteria Range: $B$1:$B$2
Click OK.
If you need VBA, record a macro or some one will help you with code.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Hello Haseeb A,
Thank you. It's working fine but I want to create a list in a new workbook. How to do it? In copy to field what to enter? How to create a list for tomorrow, week, month respectively?
Thank you for excellent suggestion.
Regards,
Mukesh
Please find the attachment to see if this works as per your requirement.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hello sktneer,
Excellent! This much I want. Is it possible to create a macro for it? Because I don't want this data available all the time. Whenever I want any data I will run the macro. There is a lot of data in my original file. I want to new file for it. 1. today 2. week 3. month.
Please create a macro to perform this action.
Thank you.
Regards,
Mukesh
Hello sktneer,
Thank you for assistance. Now my problem is solved. I have created a macro for it easily to avoide repeated steps.
Thank you to all of you once again.
Regards,
Mukesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks