Excel Divide / Split a Number into 5 parts that range between 10 and 42

What I am trying to do is I want to achieve a Specified value as sum of 5 individual numbers chosen randomly between 10 to 42. To be precise, suppose I have 165 in cell D2. Now I want to distribute split this number into 5 separate parts, each cell having random number between 10 to 42 so that when I add up the sum equals 165 or the value in cell D2.