Excel Spreadsheet VBA Code
- or -
Post a project like this3081
$$$
- Posted:
- Proposals: 5
- Remote
- #928854
- Completed
Description
Experience Level: Expert
Industry: Business
Description of excel work: Hello,
I am looking for somebody to initially write some DBA code for an an Excel spreadsheet I am working on which is detailed below. I already have some of the code I need for this but there is just one function which not not correct.
I am scanning multiple data into a sheet from a barcode scanner. The initial selected cell is D4 and when I scan the code it puts data into cells D4, E4, F4, G4 and H4, then the cursor moves across to cell J4 waiting for the next scan. After the 2nd scan the cursor currently moves down to J5 with the code below but I want it to move down and across to cell D5. I then want the 3rd scan to populate D5, E5, F5, G5, and H5 then move down to D6, then I want the whole process to start again.
This is the current code I have but it doesn't do what I need it to do.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Or Target.Row < 4 Then Exit Sub
t = (Target.Row / 2 - Int(Target.Row / 2)) * 2
If t = 1 And Cells(Target.Row - 1, 11).Value = "" Then Cells(Target.Row - 1, 11).Select
End Sub
Once I get this working want another excel sheet creating from scratch with the scanned input data. The initial spreadsheet above will create a time sheet for each of our employees. They scan a barcode which has the order number, customer name, product code and quantity when they start a job. They then immediately scan another code which has the task they are carrying out. When they finish that task they scan the order code again and it gives a start and stop time for that product and task. I can send this sheet over with some sample data and barcodes populated so you can understand the process if required. What I want the new spreadsheet to do is to extract the information by order number and product code to give us the total time spent on each task for each order. I have already made a start on the layout as an example which I've attached with example data from the first spreadsheet. I would like the ability to add to the spreadsheet myself if possible as we will be adding additional tasks and employees to the system as time goes on.
If you require any further information please feel free to ask.
Many thanks in advanve
Extra notes:
Description of excel work: Hello,
I am looking for somebody to initially write some DBA code for an an Excel spreadsheet I am working on which is detailed below. I already have some of the code I need for this but there is just one function which not not correct.
I am scanning multiple data into a sheet from a barcode scanner. The initial selected cell is D4 and when I scan the code it puts data into cells D4, E4, F4, G4 and H4, then the cursor moves across to cell J4 waiting for the next scan. After the 2nd scan the cursor currently moves down to J5 with the code below but I want it to move down and across to cell D5. I then want the 3rd scan to populate D5, E5, F5, G5, and H5 then move down to D6, then I want the whole process to start again.
This is the current code I have but it doesn't do what I need it to do.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Or Target.Row < 4 Then Exit Sub
t = (Target.Row / 2 - Int(Target.Row / 2)) * 2
If t = 1 And Cells(Target.Row - 1, 11).Value = "" Then Cells(Target.Row - 1, 11).Select
End Sub
Once I get this working want another excel sheet creating from scratch with the scanned input data. The initial spreadsheet above will create a time sheet for each of our employees. They scan a barcode which has the order number, customer name, product code and quantity when they start a job. They then immediately scan another code which has the task they are carrying out. When they finish that task they scan the order code again and it gives a start and stop time for that product and task. I can send this sheet over with some sample data and barcodes populated so you can understand the process if required. What I want the new spreadsheet to do is to extract the information by order number and product code to give us the total time spent on each task for each order. I have already made a start on the layout as an example which I've attached with example data from the first spreadsheet. I would like the ability to add to the spreadsheet myself if possible as we will be adding additional tasks and employees to the system as time goes on.
If you require any further information please feel free to ask.
Many thanks in advanve
Extra notes:
World Heat Ltd
100% (26)Projects Completed
25
Freelancers worked with
25
Projects awarded
69%
Last project
30 May 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies