+ Reply to Thread
Results 1 to 5 of 5

Bar code scanning for "today's" date

  1. #1
    Registered User
    Join Date
    01-09-2018
    Location
    Florida
    MS-Off Ver
    360
    Posts
    3

    Bar code scanning for "today's" date

    [ATTACH]555214[/ATTACH

    Hello everyone I am new to the excel game. I had help last year creating a formula, that when I scan a bar code on one of my tanks, it would populate "Today's" date in the spreadsheet. I attached a picture, A14 is where the bar code is and i want the current date to show up in AB14. Well we have switched computers in our company and things are not working so well now. I scan the bar codes and no dates populate. This is the formula that worked last year. =IF(A14<>"",IF(AB14="",NOW(),AB14),"")
    Thank you everyone
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Bar code scanning for "today's" date

    Attach a sample workbook (not image).

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

    Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    01-09-2018
    Location
    Florida
    MS-Off Ver
    360
    Posts
    3

    Re: Bar code scanning for "today's" date

    So I want to scan a bar code which will be in column A I would like to have today's date and time of when it was scanned. I hope I loaded the file correctly for you. Like I said it worked 10 months ago now we have new computers and even recreating the formula in a new Excel spreadsheet it still does not work. Maybe I'm just cutting off more than I can chew, or I'm not asking the proper question.
    Thanks again for any help and feedback!
    Attached Files Attached Files
    Last edited by spddmon66; 01-11-2018 at 04:29 AM.

  4. #4
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Bar code scanning for "today's" date

    I do not think a formula will work, as now continulally changes, and your formula is a circular reference. The only way is using Vba, and so the filetype has to be XLSM to enable macros

    A worksheet change event is the way to go, the link should help https://www.extendoffice.com/documen...l-changes.html

  5. #5
    Registered User
    Join Date
    01-09-2018
    Location
    Florida
    MS-Off Ver
    360
    Posts
    3

    Re: Bar code scanning for "today's" date

    Thanks for the help I was able to re-enter my formula as stated above and it works perfect, a little patience goes a long way.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If Sheet("Entry").range("P3") has not today date then run macro
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-20-2016, 12:13 PM
  2. [SOLVED] Macro to highlight date cells based on criteria linked to "today"'s date
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 04-08-2014, 09:18 AM
  3. condit. format: If date in cell = today, display "Today"
    By ratkins in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2013, 01:33 PM
  4. Help adding VBA code to existing macro to select "today's" date
    By kennected in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2012, 09:21 PM
  5. VBA Code for a "Today's Date" box in a userform?
    By themikeford in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2012, 09:10 PM
  6. "NOW" or "TODAY" date function
    By Chris in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-19-2006, 02:50 PM
  7. [SOLVED] Custom date format shows "051117.Thu" for today. Way to have "051117.Th", instead?
    By StargateFan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-17-2005, 06:25 PM

Tags for this Thread

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