Encerrado

VBA Macro Code for Excel

I am looking for a macro which: when it recieves an input from a USB Barcode scanner, searches and navigates within a spreadsheet to the row where the barcode already exists, and if the same barcode has a second scan within 3-5 seconds, fills in the current date in an empty cell in column 'x'. If column 'x' is an occupied cell, then it fills in the current date in column 'y'.

The macro should be activated once (when the spreadsheet is open), and subsequently run automatically after the first scan without having to re-activate for each time, as I will be running 50+ scans in a row.

I would also appreciate it if this was sent either as an excel add-in I can save to the desktop, or with full instructions to implement the code.

The columns for the date to be filled in are K and O, but are subject to change with the addition and removal of columns in the future.

Thanks for your interest!

Habilidades: Excel, Visual Basic

Ver mais: excel vba macro, spreadsheet vba code, excel barcode scanner macro, barcode scanner excel macro, column already exists, excel macro row, excel 2014 macro, barcode input excel, excel already exists, macro vba cell, macro spreadsheet, excel vba spreadsheet, vba barcode macro, excel vba macro spreadsheet, cell excel vba, excel vba cell, code scan, scan code, usb scanner, scanner usb, visual basic barcode scanner, macro scanner excel, barcode scanner usb, barcode scanner excel, vba spreadsheet

Acerca do Empregador:
( 0 comentários ) United Kingdom

ID do Projeto: #6781915

24 freelancers estão ofertando em média £22 para este trabalho

zExcel

A proposal has not yet been provided

£45 GBP em 1 dia
(254 Comentários)
7.6
maverick44000

Hi there. I have done a very similar job in Excel before and I can manage it for you pretty comfortably. I can share a sample for you to evaluate. Kindly discuss. Regards.

£30 GBP em 1 dia
(85 Comentários)
6.9
koolsidz

Hello :) I am an VB / Excel Expert. If you see my reviews by navigating to this link [url removed, login to view] then you will notice that I have not Mais

£44 GBP in 3 dias
(172 Comentários)
6.6
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Mais

£20 GBP in 2 dias
(117 Comentários)
6.3
djain01

Hello, I have more than 13 years of programming experience with Windows and Web Applications. I am well-versed with the Microsoft Technology. Proficient in programming with VB6, VB and C#.Net and different databases Mais

£23 GBP em 1 dia
(52 Comentários)
5.4
abdellatif81

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around Microsoft database (Access ,Sql Se Mais

£33 GBP em 1 dia
(9 Comentários)
4.9
Mufaddalsaifee

Hi, Thanks for posting this project. I can write this macro and also after testing i can convert into add in. I have 3+ years of experienc in VBA coding and VB.net. i have recently developed to projects which Mais

£10 GBP em 1 dia
(28 Comentários)
4.6
nmcdorman

Hello, I am an Expert VBA Developer. I write code for my company utilizing VBA to import/export data from multiple databases and sources and build Reports/Automate Tasks/Analyze Data/Store Data. Utilizing: .txt, Mais

£13 GBP in 0 dias
(1 Comentário)
3.6
pointnetfrance

Hi. I am a Senior .NET Developer living in Paris, I have read your specifications and i want to help you to realize your application. I invite you to see in my folio the kind of application i have realize for an id Mais

£19 GBP em 1 dia
(4 Comentários)
3.3
leelaaswanth

..................................................................................................................................................................

£28 GBP em 1 dia
(10 Comentários)
2.9
MasterExcel

I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high Mais

£17 GBP em 1 dia
(9 Comentários)
3.2
MKL7

Dear, I am an Excel / VBA expert and can create this very fast. Please have a look at the projects I already completed through [url removed, login to view] and the top reviews I received. I checked "the competition" as well and w Mais

£17 GBP em 1 dia
(19 Comentários)
3.3
clearatul0

I have never worked on a barcode project so I need to see how your excel sheet works. Please share as I am already working on a big energy macro project.

£23 GBP in 7 dias
(2 Comentários)
2.6
svb90792

I'll make sure you will get whatever you want from this input. Though this is my first project I can guarantee you that giving this project to me will be your best decision. Please let me know the details if you Mais

£21 GBP em 1 dia
(1 Comentário)
2.3
vw2082690vw

Hi ! I use MS Office very well as MS excel , MS Word ,Visual Basic , VBA, MS Powerpoint and work with data very well too. Thank you for your consideration, Hoang Van Tan

£13 GBP em 1 dia
(2 Comentários)
2.2
desm0ndsvw

A proposal has not yet been provided

£11 GBP em 1 dia
(5 Comentários)
1.5
praveshk

A proposal has not yet been provided

£18 GBP em 1 dia
(0 Comentários)
1.9
beardalla

Hi, I am new to here and looking to get a reputation, I am not new to IT or VBA programming, I have 4 years behind me for that. My bid assumes that you have the code to get the barcode into Excel already, as all Mais

£18 GBP em 1 dia
(0 Comentários)
0.0
carballollosa

I will give you the VBA code to implement into your process. The excel will fill the x/y cell after looked up the Bar Code input from scanner.

£38 GBP in 3 dias
(0 Comentários)
0.0
MrExcel13

I have automated several processes using vba in my current organization. so you could trust me and I am not going to in charge single penny

£14 GBP em 1 dia
(0 Comentários)
0.0