Is there any way of enabling this to happen automatically when inserting new rows without having to press control d? for some reason when I insert a new row column J's formula jumps from =H4*Spot!$I$7 to =#REF!*Spot!$N$2 when it should be jumping to =H5*Spot!$I$7 and next insert to =H6*Spot!$I$7 and so on. I have put this together for the guys on a precious metals forum and most are very limited with excel so I am trying to make it as easy as possible for them