Excel Query

Discussion in 'Software' started by JackLite, Sep 14, 2005.

  1. JackLite

    JackLite Private E-2

    Hello

    I have a spreadsheet where people fill in dates to show when work is completed but I would like to make it so all they have to do is click on a checkbox and it automatically fills in the date and time for them. I have tried =Now( ) linked to a checkbox but this changes the date when the spreadsheet is saved or re-opened.
     
    JackLite, Sep 14, 2005
    #1
  2. simplejohn

    simplejohn Private E-2

    Hey
    You should this code. replace the cell F61 as you wish :

     
    Last edited by a moderator: Sep 17, 2005
    simplejohn, Sep 14, 2005
    #2
  3. JackLite

    JackLite Private E-2

    Thanks that's great :)
     
    JackLite, Sep 14, 2005
    #3

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds