formula for A3:
I can't use formula. Here's the long version of what I need...
If the user selects a check box, then "TRUE" is put in cell J32. This part is done.
If the user deselects a check box, then "FALSE" is put in cell J32. This part is done.
I need to assign a macro to the check box, so that whenever the checkbox is toggled by the user, the macro will go and look to see whether the box is checked (TRUE) or unchecked (FALSE). If J32 = TRUE, then I need the values from G13:G14 pasted into G35:36.
So, that's the long answer. I was trying to keep the code simple initially because if someone can give me a solution for pasting the value of A2 into A3 if A1 = TRUE, then I can modify accordingly.