Trouble with an If

[Zyphlin]

Hi all. new here, have a quick question for a spreadsheet I'm working on for work.

I have a checklist spread sheet that is meant to have the user put in dates. However, to save them time, at the bottom of each collum I'm adding a place for them to say "Yes" or "No" if all the things were handed in at once. As well, leaving a cell below that for them to enter the date that they were all handed in at once.

What I need is a way to then make all the cells in the collum above it to become that same date. HOWEVER, I need to not have a formula in those cells so they can easily be typed in, just in case things aren't all done at one time.

Thanks in advance

[WinteE]

Hi,

Hope you're somewhat familiar with VBA, cause that's how you can manage this.
With the "Intersect" function it is possible to run the code only when the value of a particular range changes.

Take a look at the attached sample file.

Erik