Forum Discussion
Solved
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 ...
=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.
