Is it possible to save a selection from a data validation list into cells in a table on a different worksheet within the same workbook? The list corresponds to dates so if I go to a new date, the list clears out but I need it to save whatever was selected onto a different worksheet.
I've attached a worksheet. Basically what I'm looking for is for, when you click the approve button and select yes, it clears the form but records selection from cell i19 in a separate table on sheet2.
Thanks in advance!
timetracking.xlsm
Bookmarks