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 [R] “Watts Per Kilogram” 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 as long as it isn’t already there.
A combination of columns [K] "Date" / [O] "Weight" / [P] "HR" / [Q] "Watts" on [Dashboard] would make the unique key to be matched to columns [ B ] "Date" / [C] "Weight" / [D] "HR" / [E] "Watts" on [MAF_History] tab. If the new combination is not on the [MAF_History] tab it would get copied over.
I did try to record a macro in excel, but I don’t think the complexity can be recorded in a macro and hence the need for help from an Expert.