Hi,

I have an active X checkbox on one of my sheet. If i click the check box, i have a macro to allow the values to be overridden. The user can enter any values in the cells after he clicks the checkbox.
If the user unchecks the checkbox, the text entered by the user will be replaced by the formulas again. This works perfectly.

I have one more requirement, in which if the user enters any values in these cells, these values should replace the values in one more sheet.

If you look at the excel sheet i attached, dashboard is the sheet where i allow the user to override. Now i have one more sheet called as "Target" which has the values for the entire month already populated by using a different formula.

So here the Target sheet will have a different formula to populate the values already. When the user clicks the override checkbox, the values from the dashboard sheet for the corresponding days should replace the formulas in the target sheet.

For example,

In the target sheet on 8th, i have values as 1700(cell I11). If i click the override checkbox, this value should be replaced by cell C10 value in dashboard sheet.

The catch is, dashboard sheet will have any 15 days of the month, so only those 15 days in Target sheet should be replaced by the values in the dashboard sheet. The Rest should still reference "backup" sheet.

override.xlsm

Even here, if the user unchecks the checkbox, all the cells should be replaced with the old formulas referencing backup sheet.

Please help. Let me know if i am not clear