How do I generate a moving average in a cell - say cell "b4" , i.e.,
"=average(a1:b1:c1)".....and then put it in a macro so when a number is
copied into d1, the formula moves to the adjacent cell c4 and displays
"=average(b1:c1:d1)"?


a b c d
data data data data

formula 1 formula 2 etc....


--
drumstu
------------------------------------------------------------------------
drumstu's Profile: http://www.excelforum.com/member.php...o&userid=26467
View this thread: http://www.excelforum.com/showthread...hreadid=398297