dingdang
Member
Hi,
I have customer data base having date of birth in column H, I have applied below conditional formula to change background color in RED if date of birth match with today's date.
( only DD-MM ).
I want vba code to copy all such row based on background color or based on today's birth day to new file will save auto on desktop with file name "Birthday-dd-mm-yyyy".
attached sample file for your ref.
https://dl.dropboxusercontent.com/u/66400357/Date of Birth.xlsx
I have customer data base having date of birth in column H, I have applied below conditional formula to change background color in RED if date of birth match with today's date.
( only DD-MM ).
I want vba code to copy all such row based on background color or based on today's birth day to new file will save auto on desktop with file name "Birthday-dd-mm-yyyy".
attached sample file for your ref.
https://dl.dropboxusercontent.com/u/66400357/Date of Birth.xlsx