• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel (now) formula issie

S

Svmaxcel

Member
I want to make a small file for Sales tracking with column
Date-Time-Number-Status

I tried using Today/Now formula for Date and Time column (they both are different column)
Code: 
For Date I used

=if(c3="","",Text(Today(),"Mm-Dd-Yy")*1

For Time I used similar formula but used Now() instead of Today

So if there is a number in c3 the formula will give current Date and Current Time.
The formula works fine till here.

But now in cells below when I enter numbers, the Date and Time refreshes as per the current Date and Time.

This sheet would be used to track sales by Hours and Minutes.
But as These are voletile formula it refreshes every time, which I don't want to happen

In short once the Date and Time is calculated, it should not do it again.
 
went through the site, but its all about manual calculation, which will not help.

i guess we can make a macro something like when a number is entered in C2, VB should automatically paste current date and time in A2 and B2.

I Hope
Private Sub Worksheet_SelectionChange(ByVal Target As Range) will help here, but how can i instruct vba to enter Date and Time in corresponding Row
 
You must log in or register to reply here.
Back
Top