Scan Barcode to excel for 3 times only - Page 2
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 28

Thread: Scan Barcode to excel for 3 times only

  1. #11
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,474
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Scan Barcode to excel for 3 times only

     
    Quote Originally Posted by ygurram View Post
    Hiker,

    Please see below link to download workbook in xlsx format.
    https://www.dropbox.com/s/dep44kuaun...RAIL.xlsx?dl=0

    I have not used any Macros in this workbook except the formula written in reply#8 in Data validation.

    Thanks
    ygurram.
    ygurram,

    You have changed the worksheet format/layout several times.

    And, now you do not want a macro???

    I have examined your latest workbook, and, do not understand what you are trying to accomplish.

    Maybe someone else on MrExcel will be able to help you.
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

  2. #12
    New Member
    Join Date
    Dec 2017
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Scan Barcode to excel for 3 times only

    Hiker,

    Sorry to confuse you by changing the format/layout multiple times. I had to figure out what would be the best format to use.

    I indeed want a macro but I don't have one. I want you to help me please.

    As you can see in workbook Column 2 will be used for scanning the bar-code starting from B4.

    Lets assume part number 12345678AA is scanned by selecting B4 manually at 12:01, once scanned I need both 12345678AA and time in target row starting from L4. After 1st scan, operator selects B4 again to scan 12345678AA at 12:30 and both 12345678AA will be in M4 . After 2nd scan, operator selects B4 again to scan 12345678AA at 13:0) and both 12345678AA will be in N4. Suppose operator selects B4 again to scan 12345678BA at 13:01 and both 12345678BA and 13:01 will be in O4.

    Everytime they scan in it should add scanned part number and time stamp starting from column L.


    Same applies for part number 12345678AB/AC/AD.....


    Hope this clears!

    Ygurram.

  3. #13
    New Member
    Join Date
    Dec 2017
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Scan Barcode to excel for 3 times only

    Hiker,
    Does this makes sense?

    Yashwanth

  4. #14
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,474
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Scan Barcode to excel for 3 times only

    ygurram,

    When I started adding a macro to your latest workbook, and, tried to save it, I received the following message:

    Microsoft Office Excel

    Privacy warning: This document contains secured ActiveX controls, XML expansion pack information, or web components. These may include personal information that cannot be removed by the Document Inspector.

    OK Cancel



    Someone else on MrExcel will have to help you.
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

  5. #15
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,474
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Scan Barcode to excel for 3 times only

    ygurram,

    I downloaded your last workbook again, and, copied Sheet1 into a new workbook.

    The Job Numbers in column A, beginning in cell A4 = 1, how far do the numbers go down?
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

  6. #16
    New Member
    Join Date
    Dec 2017
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Scan Barcode to excel for 3 times only

    Hiker,

    Sorry. I must have uploaded excel file from my work laptop.

    The Job Numbers can go down to 500 starting from A4.

    Thanks in advance.

    Ygurram.

  7. #17
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,474
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Scan Barcode to excel for 3 times only

    ygurram,

    I am not able to provide a macro solution in this thread.

    Please see your other thread for a macro solution in this thread.
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

  8. #18
    New Member
    Join Date
    Dec 2017
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Scan Barcode to excel for 3 times only

    Hiker,

    I couldn't see the macro code in my other thread.

    ygurram

  9. #19
    Board Regular
    Join Date
    Apr 2009
    Location
    Northeast PA, USA
    Posts
    17,474
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Scan Barcode to excel for 3 times only

    ygurram,

    On both of your threads/posts, I have clicked on the Report button, but, none of the Administrator's have corrected the problem.
    Have a great day,
    hiker95

    Windows 10, Excel 2007, on a PC.

  10. #20
    New Member
    Join Date
    Dec 2017
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Scan Barcode to excel for 3 times only

      
    Good morning Hiker,

    I am new to Mr.Excel. Do I need to start a new thread or can I share my email ID here so that you send the code?
    Please advise.

    ygurram

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com