double a number in one columnthat is( row 48) and repeated every 48 row

[CORAL]

i have one column and i want to devide it but i want to copy the last number(afther devide) in to upcell of the column afther the column befor i think we can double a number every 48 row and then devide it how can i do it with vb

[alansidman]

Your explanation is not exactly clear. Please rephrase your question and explain it to us as if we were standing in line at Starbucks. Use specific examples addressing specific cells, columns and rows.