tahnks a lot to all
On Sat, Feb 18, 2012 at 12:13 PM, Asa Rossoff wrote:
> Hi Kal,
>
> Here's a solution using a UDF (user-defined function). It solves an issue
> I saw with the other proposals that they will generate a new date any time
> a cell is edited, even if not changed, or even dur
Hi Kal,
Here's a solution using a UDF (user-defined function). It solves an issue I
saw with the other proposals that they will generate a new date any time a
cell is edited, even if not changed, or even during any worksheet
calculation. It also works when multiple serial numbers or document IDs
hen Exit Sub
Target.Offset(, 1) = Date
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Abhishek Jain
Sent: Friday, February 17, 2012 6:01 AM
To: excel-macros@googlegroups.com
Cc: kalx...@gmail.com
Subject: Re: $$Excel-Macros$$ Date (value pest) query
I think this is what you n
I think this is what you need. It will enter current system date when you
add a new serial no. and once entered, will not change it, yesterday,
today, tomorrow, ever, :)
PS: A one line macro is used, so enable macros.
Let me know if this doesn't solve your query.
Cheers!
AJ
On Fri, Feb 17, 2
Dear Priyanka,
Thanks for your super fast reply.
I have some queries
1. At C2 there is today(), today it is 17th, tomorrow that will be 18
and all date under C2 will change, so what will be the solution
2. If I gap one day…..suppose there is no entry on 18th , so how it
calculat
kindly find the attached file
On Fri, Feb 17, 2012 at 4:30 PM, Kal xcel wrote:
> Dear Experts,
>
>
>
> I am trying to make a document tracker, where I want to put date
> automatically. If you see the attachment, when I am giving serial no.
> Document no. & date will be appeared automatically. Bu