Hi,

I am devising a spreadsheet to log the progress on a list of clients,
through a set series of procedures. The idea is that each time a certain
stage has been passed, the corresponding date is entered in the relevant
column, at that client's row.

I have thought about using check boxes by each date column, so that when the
box is checked, the corresponding date is automatically filled in.

I know that one can 'tie' a cell to a check box, and it will flip from
'True' to 'False' accordingly. I should like that box to show today's date
when ticked, and revert to blank when unticked.

If it works, there will be several hundred of these little critters, and
copying them can be a problem - they all want to 'tie' themselves to the same
cell, when I use the normal copy and paste function.

If anyone can advise on code to get the tied cell to show correct info.
rather than just True/False, I'd be much obliged.

If anyone can advise on how to get copied check boxes automatically to refer
to the next cell down, or in line, or some kind of automation/macro that I
could set up, then I'd be even more grateful.

If anyone thinks that the check-box idea is fatally flawed and/or can
propose a more elegant solution, then please let me have your thoughts.

Thank you,

Lambs