Fill column automatically based on cell value? ( vba macro help)

hello everyone :cool2:
i tried to calculated life cycle in numerology.so life cycle period filled in cell M35 - DH35 and cells are filled automatically and changed at a certain age based on the Time value (cell D6)
there is 3 period
first Period = result from single digit of month of birth except the numbers 11
second period = result from single digit of date of birth except the number 11, 13,14 16, 19, 22
third period = result from single digit of year of birth except the number 11, 13,14 16, 19, 22
example = 16 November 2038
first period = 11(not reduced)
second period = 16 (not reduced)
third period = 13 ( 2 + 3 + 8)


the birth of date data : MONTH/DATE/YEAR cell D3 , E3, F3
so life cycle period filled in cell M35 - DH35 and cells are filled automatically and changed at a certain age based on the Time value (cell D6)





example johny Time is 7 and born 9 february 1994 then cell start from M35 - DH35 filled
note : 0-99 /age = in my excel file is cell M15- DH15

hope can do it. do i need vba to solved this case ?

can anyone teach me to solve my case

Please be patient. This is a free forum manned by volunteers helping on their spare time. It might be a while before someone with the necessary knowledge is on line. It is customary to wait for about one day before bumping at free forums.
If you are in a hurry their are some commercial help services out there.
Cheers