Random normal distubution

I have a csv File that looks like :

subjects,       WeightedAverage,     WeightedStandardDev,    NumberofExams,
MathMark,              1.5,                 0.2,                   5,
PhysicMark,            1.6,                 0.4,                  10,
EnglishMark,            3,                  1.2,                  8,
PhiloMark,             8.2,                 1.5,                  9,
Others                 9.2,                 3.2,                  5,   

I have another file where I need to generate data this way for each subject above :

For example for the subject MathMark the corresponding table should be :

 NumberofExams                                     Mark                                                                              1                         =NORMINV(RAND(),WeightedAverage=1.5,WeightedStandardDev=0.2)
2                         =NORMINV(RAND(),WeightedAverage=1.5,WeightedStandardDev=0.2)
3                         =NORMINV(RAND(),WeightedAverage=1.5,WeightedStandardDev=0.2)
4                         =NORMINV(RAND(),WeightedAverage=1.5,WeightedStandardDev=0.2)
5                         =NORMINV(RAND(),WeightedAverage=1.5,WeightedStandardDev=0.2)

For example for the subject EnglishMark the corresponding table should be :

NumberofExams                                   Mark                                                                                            
1                          =NORMINV(RAND(),WeightedAverage=3,WeightedStandardDev=1.2)                                                2                           =NORMINV(RAND(),WeightedAverage=3,WeightedStandardDev=1.2)                                              3                          =NORMINV(RAND(),WeightedAverage=3,WeightedStandardDev=1.2)                               
4                          =NORMINV(RAND(),WeightedAverage=3,WeightedStandardDev=1.2)                                  
5                          =NORMINV(RAND(),WeightedAverage=3,WeightedStandardDev=1.2)             
6                          =NORMINV(RAND(),WeightedAverage=3,WeightedStandardDev=1.2)   
7                          =NORMINV(RAND(),WeightedAverage=3,WeightedStandardDev=1.2)
8                          =NORMINV(RAND(),WeightedAverage=3,WeightedStandardDev=1.2)

want to produce NumberofExams random numbers with normal distribution (with WeightedAverage, WeightedStandardDev) . How can I get these informations from another csv and calculate the wanted random numbers in Excel . Any formula or Macro is welcomed