I have tab called Dashboard that has recent data and I also have a tab called MAF History containing the same date for older time frames. Once the Watts Per Kilo Gram on the dashboard page goes from 0.00 to a value higher than 0.00 I would like to have it copied to the MAF_History tab so that it can be included in the chart. I want to make sure the vba will not copy duplicate records, just records that are new should be copied to the MAF_History tab. Instead of having to click a button to copy over the data, it would be preferred to have it happen as soon as a new value is updated.
I purposely have the data on the Dashboard page in column K6, then columns O6:R6 because that is where they are on my master template.