• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy entire row if date of birth match with todays date

dingdang

dingdang

Member
I have customer database with date of birth in colour F, I have added conditional format if DOB
( only dd-mmm ) match with today then entire row is in red color.

I want to copy all such row in separate sheet as an when file open.

in short I want separate list of customer having today birthday from database.

e.g ........if DOB is 01-dec-1968 the entire row is in red colour 1st december every year.

Pls guide
 
Sir,

Thanks for info..but how to select row which depends on conditional format.as date are changing every day as per DOB.
 
Dingdang,
How did u match the dates with today, only dd-mm .i.e. how did u extract only dd-mm from dd-mm-yy & then did conditional formatting?
 
vrunda,

have apply below formula In conditional format

=AND(MONTH(TODAY())=MONTH($F7),DAY(TODAY())=DAY($F7))

Format… [Fill colour RED]

If date of birth match with coloum F then entire row is in Red , i just want to auto copy all such red row to next sheet seperatly.
 
Hi Dingdang,

Please see the attached file. I think it meets your requirement. I had use VBA for achieving this.

If you had any particular doubt about the code, please tell.

Regards!
 

Attachments

  • Workbook1.xlsm
    56.2 KB · Views: 9
@vrunda
If you see the file I had attached I had use below formula to achieve the CF.

=DATE(,MONTH(TODAY(),DAY(TODAY()))=DATE(,MONTH($B3),DAY($B3)))

Considering the date of birth are in Column B.

Regards!
 
You must log in or register to reply here.
Back
Top