Hi everyone! First post here and excited to get involved.
I have a dropdown in B3 and I would like to clear the contents of cells B6:V6 upon any change in the dropdown.
Also, I would like to reset cell A6 to today's date when that same dropdown is changed.
For simple background, people will be entering a series of information in row 6 and then submitting it. Usually, it will be entered with today's date, but sometimes there's a need to enter past info. I want to ensure that if someone enters a previous date, the next person wouldn't have to reenter "=TODAY()" into cell A6.
Many thanks for any help you can provide!!
Greg
Bookmarks