Hi all,
Column A is made up from a Validation list. What I need is the following:
When A2 changes from blank to an entry from a dropdown option, B2 changes to the current time and date. I want this time and date to remain as it is and never change when the document is closed and reopened.
For example, as of right now I drop down the A2 entry to Emma, B2 would change from blank to 14:51 27/01/23 and always remain at that time and date. The same needs to happen the whole way down the document.
Just to add some news - this cannot be achieved by using VBA and or Macros as these are disabled for our work laptops.
Any help or steering in the right direct for this would be a massive help.
Thanks
Emma
Column A is made up from a Validation list. What I need is the following:
When A2 changes from blank to an entry from a dropdown option, B2 changes to the current time and date. I want this time and date to remain as it is and never change when the document is closed and reopened.
For example, as of right now I drop down the A2 entry to Emma, B2 would change from blank to 14:51 27/01/23 and always remain at that time and date. The same needs to happen the whole way down the document.
Just to add some news - this cannot be achieved by using VBA and or Macros as these are disabled for our work laptops.
Any help or steering in the right direct for this would be a massive help.
Thanks
Emma