Find Jobs
Hire Freelancers

Excel VBA Inventory Scanning Barcode

€12-18 EUR / hour

Kapalı
İlan edilme: yaklaşık 6 yıl önce

€12-18 EUR / hour

Hi, I am trying to improve the inventory control and automation for my company. Each product we have is individually labeled with a bar code that contains a GTIN (14 Digits) and Lot Number (7 Digits). I have programmed my barcode scanner to separate out the GTIN and Lot Number. I need a bar code scanning template created in excel with some VBA Script where each bar code would be scanned and the item number and lot number would be counted. As multiple GTINS with the same Lot Number would be scanned the quantity would increase (as per the attachment). If the same GTIN with a different Lot Number is scanned it would appear as a different line item on the excel sheet.
Proje No: 16378827

Proje hakkında

24 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 6 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
24 freelancers are bidding on average €19 EUR/ saat for this job
Kullanıcı Avatarı
Hello, I am expert in Excel VBA and like to handle your project and discussing it with you. Regards, Iyad
€50 EUR 40 gün içinde
4,9 (44 değerlendirme)
7,5
7,5
Kullanıcı Avatarı
Hi there,I am Miljan,IT expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me. There is a lot of experience behind me, so it will be a huge satisfaction for me to do this job. Please feel free to contact me so we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Kind regards
€16 EUR 40 gün içinde
4,8 (136 değerlendirme)
7,4
7,4
Kullanıcı Avatarı
Hi There, I have created more than 500 macros so far and this looks feasible as well. I am an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks Aman
€27 EUR 3 gün içinde
4,9 (178 değerlendirme)
6,6
6,6
Kullanıcı Avatarı
Hi, I am well versed with writing VBA in Excel, Word etc.. I have used written VBA extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in Excel VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 10 years of experience to my credit. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
€15 EUR 30 gün içinde
4,8 (149 değerlendirme)
6,1
6,1
Kullanıcı Avatarı
- Can get the logic to be used in barscanned excel data where the GTIN and lot number is present. - Using scripting can get the Same GTIN with different lot number to be appearing on a separate line. - Have expertise in Excel macros and can get this working on click of a button. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data consolidation, data comparison, pivot, lookups, summaries My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries.,
€13 EUR 40 gün içinde
4,7 (53 değerlendirme)
6,0
6,0
Kullanıcı Avatarı
Greeting, I have understood your Excel VBA Inventory Scanning Barcode task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps
€18 EUR 40 gün içinde
4,8 (13 değerlendirme)
5,2
5,2
Kullanıcı Avatarı
i This is Piyush Patel I have 10 yrs of Exp in VBA,VB6.0,VB.net and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start i can give solution in vb6.0 + Access Database with same GUI. so you can Print Report and Export Report in Excel With some More Filter Criteria. Enter Date and Scan barcode and Check Reports with Print and Export to Excel Option. if you want i will send demo. waiting for your feedback on same.
€22 EUR 4 gün içinde
5,0 (28 değerlendirme)
5,1
5,1
Kullanıcı Avatarı
I am an Australian business analyst with 15 years building automated reporting and tracking solutions using Excel and VBA - including stocktaking solutions. I was wondering what you think about converting the output on inventory taken to a pivot table which counts the data on the 'scans with datetime stamp' page (the scans with datetime stamp page would obviously be populated by the individual scan) which is refreshed each time an item is scanned? I would also suggest adding a 'last item scanned' section so the user can easily see (and depending on your preference edit, in case of accidental double scanning) this information in case they lose their place / aren't sure something went through. Also I'm assuming the barcode scanner also sends an enter character with each scan - is that correct? I would love the opportunity to chat with you further about your project!
€17 EUR 8 gün içinde
5,0 (28 değerlendirme)
5,1
5,1
Kullanıcı Avatarı
Hi, I went through your job description This is pretty interesting job I am willing to discuss with this and have confidence to complete. Kindly review my past job and I am looking for a challenging task. I am looking forward to hearing from you Cost can be negotiated Thanks Regards Thushara
€13 EUR 10 gün içinde
5,0 (26 değerlendirme)
4,4
4,4
Kullanıcı Avatarı
A proposal has not yet been provided
€18 EUR 12 gün içinde
5,0 (7 değerlendirme)
3,8
3,8
Kullanıcı Avatarı
Hi I can handle it. looking forward............................................. .................................Thanks
€16 EUR 40 gün içinde
3,9 (11 değerlendirme)
4,3
4,3
Kullanıcı Avatarı
hello sir, I have 3 years of experience dealing this type of projects. Let me help you for better outcome. Thanks.
€16 EUR 40 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Dear Customer, is it needed to write everytime in the same exesheet? or do you want to crate a new .csv everytime you connect your scanner via usb?
€22 EUR 4 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
A proposal has not yet been provided
€16 EUR 10 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
You can release the payment once you're 100% satisfied with the job .
€33 EUR 40 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
We are confident that our intimate familiarity with the Oracle EBS application . And our deep knowledge of EBS function processes and confidence in delivery capability will result in a Win-Win situation for both Side. We can Oracle Apex Application No need pay Any license cost for future purpose We Are completed so man y project regarding barcode related
€16 EUR 40 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   IRELAND bayrağı
Ireland
0,0
0
Şub 26, 2018 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.