I am fairly new to VBA codes and have been trying for days to get this spreadsheet to accomplish the end results I would like. I have a few questions and need some direction on a few things surrounding the check boxes. The desired function of this spreadsheet is to be able to keep track of tasks current and completed.

- When checking a box (column B) I would like the date the box was checked to appear in the date completed column (Column J). I've been able to format other changes (row color) if the box is checked but no luck with date.

- The ability to move checked rows to another tab (Not Immediately) but at least once a month. Is this feasible?

- A formula to accurately calculate the "Percent Complete" chart based off the amount of current tasks checked off in column B and content filled in C instead of a set number in a formula (inaccurate).


Any guidance, added suggestions, or help regarding these issues would be greatly appreciated!!!!to do.xlsm