DerfNotwen
New Member
- Joined
- Mar 27, 2018
- Messages
- 6
Long ago in a land far away I used to use Excel all the time, but since then things and I have moved on and my Excel skills have grown rusty.
We have a spreadsheet, on which we need to record Client orders and the date/time they were received and, subsequently, dispatched.
What I would like to achieve is the date/time received fields auto-complete when the client name is entered.
I started with =IF(A2<>””, Now()) , which is all well and good as long as I don’t enter anything else on that page, otherwise it updates with the date/time when the next client details are entered.
Is there a simple way to stop this happening please, or do we have to resort to macros ?
Thanks and regards
Fred
We have a spreadsheet, on which we need to record Client orders and the date/time they were received and, subsequently, dispatched.
What I would like to achieve is the date/time received fields auto-complete when the client name is entered.
I started with =IF(A2<>””, Now()) , which is all well and good as long as I don’t enter anything else on that page, otherwise it updates with the date/time when the next client details are entered.
Is there a simple way to stop this happening please, or do we have to resort to macros ?
Thanks and regards
Fred