Sportz Zone Cardz
New Member
- Joined
- Feb 13, 2023
- Messages
- 1
- Office Version
- 2010
- Platform
- Windows
Hi,
I'm trying to create an inventory sheet on excel. How I'm able to scan in a barcode on cell B3 and move all the data down one row only for column B, not the entire row. I would like this to work for each separate columns so if I scan a barcode on cell C3, all the data just on column C will move down a row. Also, is it possible to freeze the cursor on cell B3,C3,D3,E3,F3,G3, and H3, so for example if I click on cell D3 the cursor stays there while I'm scanning the barcodes and all the data keeps moving down a row. Any Ideas?
I'm trying to create an inventory sheet on excel. How I'm able to scan in a barcode on cell B3 and move all the data down one row only for column B, not the entire row. I would like this to work for each separate columns so if I scan a barcode on cell C3, all the data just on column C will move down a row. Also, is it possible to freeze the cursor on cell B3,C3,D3,E3,F3,G3, and H3, so for example if I click on cell D3 the cursor stays there while I'm scanning the barcodes and all the data keeps moving down a row. Any Ideas?