Hi, I'm pretty good at Access but rarely use Excel and I need some assistance
please. I have several columns with a total at the bottom of each. At the
top there is a check box which copies the column and pastes to another sheet.
It erases the column in the second, destination sheet if the check box is
deselected. The problem is that if someone changes a value somewhere in the
column the cells in the destination sheet do not update, you would have to
deselect and reselect the check box. I want the deselect, select action to
happen if the contents of the total cell change.

Thanks for the help!