There isn't an easy way to do it if thats what you are really trying to
do!, to copy a formula down one row would adjust for that row unless
using absolute referencing, but as your increments aren't uniform it's
near impossible without vba to do this.
--
Simon Lloyd
Regards,
Simon Lloyd
'The Code Cage' (
http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.thecodecage.com/forumz/member.php?userid=1
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=39061