Auto Calculate Macro

To all,

I need some help with calculating a formula with a MACRO,


In one sheet I have an series of averages ( A2:A, sheet1) -


In another sheet I have a series of standard deviations (A2:A, sheet2)


In a sheet called "calulation" - I want to be able to do the following


In column B:2 - Calulate = (average - 777)/Standard deviation


and then calculate this formula down the column, and to stop when there

is no standard deviations or averages in the relevant rows in the other

sheet1 and sheet2.


Any help with this macrowould be appreciated.


Thanks in advance,


Regards


Joseph Crabtree