Results 1 to 3 of 3

Enter data into a cell have comment generated with the current date and time

Threaded View

  1. #1
    Registered User
    Join Date
    12-05-2011
    Location
    Lithuania
    MS-Off Ver
    Excel 2003
    Posts
    3

    Enter data into a cell have comment generated with the current date and time

    In a worksheet i use cells from B3:B22toG3:G22(bcdef...) but i don't fill all the data in one time.
    It is necessary that when i enter the data into a cell, a comment would be generated with the current date and text(text would be nice, but not realy necessary). For example "the customer was registered: 2011.12.05" the date has to remain static.
    Is there any way to do it? I tried some things with macros, but i'm starting to give up.

    thank you in advance, and sorry for my english.
    Attached Images Attached Images
    Last edited by soulfriend; 12-06-2011 at 05:25 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1