Dear All,
Please allow me to ask you how to create a time stamp which will be based on the drop down list.
I would like to change date and time in column 'E' only when I do some changes in column 'D' only. I would like to see something like per column 'B'. I attached my spread sheet in working progress for your use.
Any help would be much appreciated.
Best regards,
Jan
Right Click on your sheet name at the bottom of excel and select view code
Paste this code into the module that opens and close it.
Please Login or Register to view this content.
If you want date stamps in all of column D then use this code instead.
Please Login or Register to view this content.
Last edited by mehmetcik; 08-05-2018 at 02:30 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Dear Mehmetcik,
Further to your helpful response I came across with the issue which I cannot deal with.
When I open the spreadsheet it gives me an error saying ''There are one or more circular references where a formula refers to its own cell either directly or indirectly. This might cause them to calculate incorrectly. Try removing or changing these references, or removing the formulas to different cells.''
Is it something you can help/advice with?
The spreadsheet is to big to attach it here, therefore please follow the link to the file:
dropbox.com/s/q0v16y1aejgfj3x/Work%20List.xlsm?dl=0
Kind regards,
Jan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks