Or, to not clutter the file with extra formulas, right click sheet tab>view code>insert this macro. When you make any entry in col B col C gets todays date which won’t change unless you change col B cell
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column <> 2 Then 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 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, 2012 at 4:51 PM, Kal xcel <kalx...@gmail.com> wrote: 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 calculate next day, means 19th. Please help me through your solution. Thanks in advance. -- Kalyan Chattopadhyay Executive Sales Coordinator R. S. H. Pvt. Ltd. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
