+ Reply to Thread
Results 1 to 3 of 3

Date entry no matter which cell in a row gets data first

  1. 11-12-2012, 01:03 AM #1
    Gwaii
    Gwaii is offline
    Registered User
    Join Date
    10-27-2012
    Location
    BC Canada
    MS-Off Ver
    Office Pro Plus 2010
    Posts
    3

    Date entry no matter which cell in a row gets data first

    I have a sheet that I am entering pump hours into and would like to have the date show up in the first cell no matter which cell in the row gets data inputted to it first. Each row is one days data entry. I already have it working in the first cell using the following formula: "=IF(B3<>"",IF(A3="",TODAY(),A3),"")" but I don't know how to add the rest of the cells that are in the row. The other cells that I am wanting are: F3,J3,N3,R3,V3,Z3,AD3,AH3, AL3. This is in case someone starts entering from the other end or in the middle even. Any one of those cells should cause the date to be entered in the first cell of the row. This formula will have to be carried down the form as well so that every day has the same effect. Hope this makes sense, any help would be greatly appreciated!


    Pump Run data entry form Nov 11 2012.xlsm
    Reply With QuoteRegister To Reply
  2. 11-12-2012, 01:16 AM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Date entry no matter which cell in a row gets data first

    You can't put the date in column A with a formulaic TODAY() reference, because each time you open the workbook the formula will update to present the current day's date, the wrong long-term result.

    To get a date placed in column A that is static, it must be a text entry. For it to happen automatically requires VBA.

    1) Right-click the sheet tab and select VIEW CODE
    2) Paste in this event macro into the sheet module that appears:
    Please Login or Register  to view this content.
    3) Edit the macro above to use the correct password for the sheet.
    4) Close the editor.

    Now anytime you make a manual edit anywhere on the workbook it will add the date in column A if it that cell is empty.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 11-12-2012, 12:47 PM #3
    Gwaii
    Gwaii is offline
    Registered User
    Join Date
    10-27-2012
    Location
    BC Canada
    MS-Off Ver
    Office Pro Plus 2010
    Posts
    3

    Re: Date entry no matter which cell in a row gets data first

    I have tried putting this into the sheet as you describe but nothing changes at all. If I enter data in cell J3 for instance nothing changes and no date is input into cell A3? Did I do something wrong? I copied and pasted like you said and added the password in between the quotes. Please let me know what I am missing. Thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1