Hi John,

That's perfect, just what I wanted!

I tried to adapt it into my workflow but got lost where you defined 'j', I'm a noob when it comes to VBA.

I have done away with worksheet 1 and now just have my 'bond schedule' tab and 'coupon timeline' tab.

How would I adapt the macro so that I could make 'coupon timeline' from my 'bond schedule' tab. Its a big askCoupon Schedule Update.xlsm