Forum Discussion
Datalogic scan to Excel
Hi,
I would like to scan some data into in excel in two columns eg. A1 then B1, A2 then B2 etc..and thereafter make some meaningful reports from the scanned data. However, the scanner Datalogic Magellan 3410VSi would only scan and enter to the below cell i.e. starts at A1 then goes to A2,A3 etc. I have tried to look for technical support to program the scanner to tab right but I seem to be heading nowhere.
My excel has two columns with headers Stock no. and staff ID. Would it be possible to work around this problem ? Would really appreciate to get a solution..
=OFFSET(A2,ROW(A2)-1,0,1,1)
=OFFSET(A2,ROW(A2)-2,0,1,1)
Not sure what could go haywire when using the VBA code in the attached file. The data is arranged in alternating order in column A and the code is adapted to these conditions. Maybe you want to use the above formulas. Enter them in cells B2 and C2 and fill down. Then copy the results and paste only values. Finally delete the "0" results in the lower half of columns B and C.
9 Replies
In the attached file when you click on the button in cell F2 the data from column A is split into 2 columns B and C. Is this what you want to do?
- Thank you Q_Pawn..
The output is what I would like to have but since I am not good with VBA, I am afraid, if things go haywire, then I am stuck.=OFFSET(A2,ROW(A2)-1,0,1,1)
=OFFSET(A2,ROW(A2)-2,0,1,1)
Not sure what could go haywire when using the VBA code in the attached file. The data is arranged in alternating order in column A and the code is adapted to these conditions. Maybe you want to use the above formulas. Enter them in cells B2 and C2 and fill down. Then copy the results and paste only values. Finally delete the "0" results in the lower half of columns B and C.
