The script below triggers every couple milliseconds due to the Worksheet Calculate event and then copies from my Pivot Table to the Chart Helper. Script works great but when it copies the next iteration of data it pastes it after the original data set it just copied. I need it to continuously paste over the… Read More Copy Iteration Issue

My Worksheet_Calculate event works well. However when it pastes it finds the next open row on sht2 then once the event is trigger again it re-pastes over the original row it pasted the first time. Goal is to copy/paste A39:Q39 in the next available row each time the event is triggered on sht2 and not… Read More Copy/Paste to Next Row