1. In excel 2013 , can you scan a barcode so that that barcode takes you to n spesific block A1 on a specific sheet. ?
2. In the first sheet i have in colum A serl. no.s , in colum C a bar code no.s and in colum D a Name.In another Sheet i scan items in RANDOM BARCODES , I want the name and serl. number to appear in the blocks next to it from sheet 1 ?
1 SHEET
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>2 SHEET
<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
2. In the first sheet i have in colum A serl. no.s , in colum C a bar code no.s and in colum D a Name.In another Sheet i scan items in RANDOM BARCODES , I want the name and serl. number to appear in the blocks next to it from sheet 1 ?
1 SHEET
A | B | C | D |
Serl. No | Bar code | Bar code no | Item name |
BWStock00001 | 6001599054393 | Diary | |
BWStock00002 | 6001015506017 | tin | |
BWStock00003 | 6001007316884 | Paper Towl | |
BWStock00004 | 6001007160937 | toilet paper | |
BWStock00005 | 6001087006033 | HAMMER |
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>
A B | C | D | E | F | G | |
Barcode no | Serl. no. | Item Name | Units | Price | ||
1 | ||||||
2 | ||||||
3 | ||||||
4 | ||||||
5 | ||||||
6 | ||||||
<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>