Hello Forum,

Does any one know of a way thru a formula to post a date into a cell based on an event happening on other sheet.  

I have a sheet that makes a random selection of people from my roster whereby I copy the selection and paste the values into cells on the same sheet in a different column.  The thing is however, I have another Sheet in the same workbook that I need to have the selection date, the paste event date, based on the selection of the individual(s), placed/posted/dropped into the appropriate column/cell as applicable.  

Can anyone help me out with this?

Carl

​Hello Forum, Does any one know of a way thru a formula to post a date into a cell based on an event happening on other sheet.   I have a sheet that makes a random selection of people from my roster whereby I copy the selection and paste the values into cells on the same sheet in a different column.  The thing is however, I have another Sheet in the same workbook that I need to have the selection date, the paste event date, based on the selection of the individual(s), placed/posted/dropped into the appropriate column/cell as applicable.   Can anyone help me out with this? Carl  Read More

​