I am not clear is you are using VBA or just plain formulas..
If you are using formulas, just drag and fill, unless you have absolute
reference to your cells in the first row, It should work ok.
If you are using VBA, you would have to include the other rows into
your codes.
--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile:
http://www.excelforum.com/member.php...o&userid=35016
View this thread:
http://www.excelforum.com/showthread...hreadid=572754