LinkBack URL
About LinkBacks
Hello, i need a formulla do the following
If Cell B2 contains any Data, Fill Cell A2 with Now date and time, if B2 Contains nothing Keep Cell A2 empty
Hello, i need a formulla do the following
If Cell B2 contains any Data, Fill Cell A2 with Now date and time, if B2 Contains nothing Keep Cell A2 empty
This works in A2:
Formula:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hello and thanks for the Reply, its working Exactly as needed, but when i copy the formulla to the whole column and try to
use the cells that should add the now date and time all date and time of the column are changong to the same,
lets say i added 1 entry now and after 2 min another entry all are changing to now time and date.
Maybe this:
Formula:Please Login or Register to view this content.
=IF(G3<>"",NOW(),"")
this formulla is working nice but 1 issue is when copying the formulla to the whole column and start putting data
its showing all date and time exactly the same even if there is diffrence . can any one help me plsss.
Last edited by marko737; 04-15-2019 at 09:42 AM. Reason: Not Fixed Yet
NOW() is Volatile, hence it will keep updating. You'd need VBA for this.
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hello and thanks for the reply, no one has found and solved the problem,
i have atached the workbook as per your request
all details are inside.
thanks for your help.
Are you trying to timestamp your entry time.
If so put the attached code into your worksheet code window (right click sheet tab > view code > copy & paste code in)
torachan.
Please Login or Register to view this content.
Last edited by torachan; 04-19-2019 at 03:13 AM.
This should do it.
Copy the code from below, then go to Excel. Right click on the tab (the bit that says 'Sheet1') that you want the code to run on, then click 'View Code'.
Paste the code into the empty box.
Close the code editor.
Save your workbook as a 'Macro Enabled Workbook'
Please Login or Register to view this content.
Last edited by jason.b75; 04-19-2019 at 03:26 AM.
It works 100% As Needed. Thanks a lot Dear.
It Works Gr8. Thanks Dear
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks