hello everybody.. and happy new year.. I need a VBA code to do the following:

in sheet 1 I have a range J8:J57. Here I have some numbers that I need to be equally divided into cells in sheet 2. Right now I am using the following formula: =ROUND(sheet1!$J$9/96;14). I then pull this formula down 96 cells to have the result. Then I move on to the next cell and do the same with the following formula: =ROUND(sheet!$J$8/96;14).

This takes forever and, most important, is bound to create a problem if one of my colleagues deletes the formula from the cell.

Is it possible to have VBA to do the job by selecting the cell and its destination range (ranges can vary between 96 and 125 cells)...?

Also, is it possible to have the function update the destination cells whenever a change is made on sheet1?