Hi Molloy,

Thank you very much for the code, it works fine but i have a question.
If the main sheet has 10 updates and if i run the code in formula
sheet, it updates only one record, How can i extend this ocde so that
the formula is applied to the equal nunber of rows updated in main
sheet.

Thanks in advance.
Chetan.J