Forum Discussion

A_SIRAT's avatar
A_SIRAT
Iron Contributor
Jan 03, 2022
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 ...
excel
  • OliverScheurich's avatar
    OliverScheurich
    Jan 03, 2022

    A_SIRAT 

    =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.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jan 03, 2022

A_SIRAT 

=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.

A_SIRAT's avatar
A_SIRAT
Iron Contributor
Jan 03, 2022
Thank you again ! This works for me .

Resources