Dear Dave, Thanks for paying attention,
Yes I am allowed to use Macro & I want the date in Col B only when the adjecent cell Col A received some text for the first time Regards Ramkesh On Wed, Sep 29, 2010 at 7:50 AM, Dave Bonallack <davebonall...@hotmail.com>wrote: > A further question: Do you want the date in Col B to enter only when the > adjacent cell in Col A receives text for the first time, or any time the > adjacent Col A cell is changed? > > Regards - Dave. > > ------------------------------ > Date: Tue, 28 Sep 2010 23:40:09 +0530 > Subject: $$Excel-Macros$$ > From: sunscel...@gmail.com > To: excel-macros@googlegroups.com > > Dear All, Xl Mania(s) > > I really appreciate this group for learning > I have lrarnet a lot of tricks from this group which enabled me to come of > with flying colours.Today i am posting my first query briefing in below > lines----------- > > 1- I fill some text in column A (say) > 2- I want that the date of filling data should appear in column B (beside > the column A) > > Now condition is ----- > > 3 -Date in column B should not be updated by re-calculation nature of > Excel or user > > > I know that anybody will help me so thanks in advance ! > > -- > > Ramkesh > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Ramkesh 9990260398 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
