am using a barcode scanner to read in barcode numbers into excel. But everytime after I scan a barcode, excel moves to the cell in the next row. What I want is moves down to the next column. Anyone with information please help.
@Poscatch
4 жыл бұрын
Excel is not doing that, your barcode scanner is. Check the user's manual of your barcode scanner to see how to program it to perform the function you want. Or you can contact the manufacturer's tech support of your scanner and ask them for help.
@muhammedrashidkp9581
4 жыл бұрын
@@Poscatch I saw the automatic bottom cell being selected while scanning in this video of yours. The cell on the right is selected when I use the barcode scanner.
@shandenesolomons1809
3 жыл бұрын
Carriage Return or CR needs to be set on the terminator field of your barcode scanners setup. It basically acts as if you were pushing the Enter key on your keyboard.
@mzorong4491
3 жыл бұрын
Try to setup enter function
@funckystar3951
Жыл бұрын
You can probably try kzitem.info/news/bejne/ppiXm6OQpWKXeqQ
@mipueblitowesternwear1986
3 жыл бұрын
Thank you so much! Do you have a video explaining how to put an identifier so that the scanner says what the item is once we have scanned it? Thanks a bunch!
@jordanlee2262
4 жыл бұрын
How do I decrease my inventory if I scanned?
@sherrysullivan-jq1rn
4 ай бұрын
how do you scan items out?
@quarterlore6272
3 жыл бұрын
Great video. Is this only for taking a one time inventory, or is there a way to keep a running tally and scan in additional items down the road that will be added to the running total?
@Cra19y1
2 жыл бұрын
Have you managed to find out this?
@quarterlore6272
2 жыл бұрын
@@Cra19y1 This was a while ago but I set it up to add the barcode to a column everytime it was scanned, then used a formula to count the number of times each number appeared and spit it out in another cell for each item.
@audthenoble4455
2 жыл бұрын
Dear lord thank you for this !!!
@VickiBrun
Жыл бұрын
I don't understand how the scanner scanned the info to the sheet. How did you connect the scanner to the sheet? And how can you use this as a pos record to record what you sell.
@BarcodeFreeware
2 жыл бұрын
Great tutorial, easy to follow, in just a few minutes you will learn to Track Inventory in Excel with a Barcode Scanner.
@muhammadarsalan6822
Жыл бұрын
Great Sir Thankyou very very much❤
@mamadoudiomande8009
3 ай бұрын
Thanks for your great video
@This_Planet
Жыл бұрын
love it - you can type or obtain a list of items then and paste them in the sheet and index i believe. that way the description pops up.
@hansonatangha7677
6 ай бұрын
Excellent video. Well explained and easy to follow. Please what if i have a lot of stuff to count but the barcodes are item specific?
@logospgs
Жыл бұрын
Thank you for this video! I work in order processing and quality assurance and was tasked with finding a good system to inventory with a scanner. Excel and google sheets are officially my best friend.
@davidemmanuel3001
4 жыл бұрын
I love your volume
@nivoonairam8950
Жыл бұрын
after you ad item descriptions in that extra column you added, would that pop up later if I scanned the bar code?
@joanlopez4918
10 ай бұрын
is it possible to have : multiple bar code readers scan barcodes to different areas or boxes depending on the bar code scanner used?
@todds5956
10 ай бұрын
Will this work with Ford part numbers?
@kirsten39
6 жыл бұрын
thank you for the info and helping out a small business!!!!
@bj5563
4 жыл бұрын
How do we then "Scan Out" items from the inventory when we want to use the? (ie. reduce the number when scanning barcode) Thanks!
@semmie1994
4 жыл бұрын
I wanna know that as well.. do you have a answer on that question already?
@MrTobiascollins
2 жыл бұрын
Is there a base for this to be able to communicate with the computer?
@FelipeCampelo0
7 ай бұрын
Do bar codes match SKUs ?
@OluFunsoIbrahim
10 күн бұрын
can you do this on on google sheets?
@ansonkiek6471
2 жыл бұрын
Just wanted to ask, my barcode scanner can detect by Hercules serial , but I can’t detect on my software serial input. Is this has to do with port 2,3 RC , TX reverse problem ? The programming software only have serial input selection and setting such as baud rate same as scanner but still can’t trigger Is this no need any driver or software install on data logic power scanner 9330 series ?
@mzorong4491
3 жыл бұрын
Our scanner can scan or very well
@chelseaphillips7172
2 жыл бұрын
so after you do this part, how do i set it up so that i can use my barcode scanner to scan the barcodes of the things i'm pulling from my inventory or when i get new inventory in to add it to the sheet easily without having to manually enter everything. I'm looking for something that i can scan my barcode, it registers it and can subtract ex. 2 shirts from my stock if i need to pull 2 shirts.
@callitaitz7153
4 жыл бұрын
Do you know how to start a new count for an item that has a previously used barcode? Like if you get a new shipment of inventory that has the same barcode as a previously used shipment, is it possible to start a new count?
@nivoonairam8950
Жыл бұрын
can you use a basic bar code scanner that I bought for 10 bucks on amazon?
@jodyodom4978
2 жыл бұрын
How can I have this track incoming and outgoing items being checked out at the cash-register? We do not want to use a cloud based product.
@shailjasgh
3 жыл бұрын
I have a big clothing inventory, all barcoded, and I just want to use this to list contents in each bin. If I have 50 bins, can I use 50 columns, one for each bin and scan items under each bin? Wouild that work?
@ShakilKhan-dt9vt
6 жыл бұрын
Hi there it was great watching the video. With this video it will record the inventory. How to keep a track of outgoing inventory please
@neusb6286
3 жыл бұрын
HI,how I can remove products that I use from the stock with the scan reader ,please?
@AunaliBandali
3 жыл бұрын
I want a barcode which will scan the description on the excel sheet . Any idea ?
@slimjim1690
2 жыл бұрын
Looking for help with scanning barcoded assets In & Out . List of assets, their barcode numbers and date/tim scanned in date, date/ime scanned out. To track expensive tools etc
@JustMeda
Жыл бұрын
Thank you !!!
@HYA782
2 жыл бұрын
my excel didn't give me the option for subtotal when I go to Data. plz help
@WorksopGimp
6 жыл бұрын
How would you scan out? Please
@bibeklamshal9596
4 жыл бұрын
hi, if the barcode entered is the same in a cell 2nd time then increase only the quantity in "quantity" but not go down unless new barcode enters. How to do this? or from VBA code you can guide me?
@advsadaqatayubrao8731
7 жыл бұрын
if i enter manually barcodes in this sheet than the sheet manually entered barcodes are showing in one by in diff column, so kindly help me if i scan barcodes with barcodes scanner or manually barcodes enter quantities showed in a column.
@sapna57
7 жыл бұрын
Thanks for making it so easy
@WorksopGimp
6 жыл бұрын
Just what i was looking for, thanks
@hermanahdiat2566
3 жыл бұрын
Is it only use that barcode scanner tools and Excel ?
@rizwanaliyasin5848
4 жыл бұрын
please advise i have date on excel sheet with barcodes and then i want to scan check the item excel to match with barcode scanner how to do this
@okykedu7372
3 жыл бұрын
thank you for helping me
@rch19660
7 жыл бұрын
Thanks, Saved me a lot of work.
@oktavia4903
3 жыл бұрын
Great video. How can i assign the barcode to product name? Can ya advice any formula? Thanks
@crazysleepintime
Жыл бұрын
Add a new tab with two columns for unique barcodes and product names - use columns A and B, respectively. Call the tab Product LKU TBL. Then in the first tab with all the scanned barcodes, in next column over use =VLOOKUP(A2,'Product LKU TBL'!A:B,2,FALSE). This assumes the scanned barcodes are in column A.
@afifdotkom
Жыл бұрын
@@crazysleepintime Thanks alot.
@ladyhamo20
6 жыл бұрын
How about if you want to count these items by cases or does it only counts it by eaches?
@MUNBYNPOSscanner1printer
6 жыл бұрын
Very good training. THANKS.
@Gizard1000
7 жыл бұрын
I am based in UK and I like your inventory video, it is something I think I might us. How do I get my scanner is connected to my PC.
@Poscatch
7 жыл бұрын
Please watch this video to see how: kzitem.info/news/bejne/1ax5uZmOaZOTfZw
@Rivenworld
7 жыл бұрын
Brilliant, thanks, at last I can now use my scanner... ;-)
@alyviasteenhoek2422
6 жыл бұрын
Hi, is there a way to scan a barcode, and locate it within excel? Say, you already added in several barcodes, but when you scan it again, it takes you right to that cell, rather than adding it to the excel sheet?
@GEOVANNETY
5 жыл бұрын
hola buen dia, te hago una consulta tengo una lectora symbol ds6878 la base enciede y luego de 2 segundos se apaga, sera q tiene que leer algun codigo para solucionarlo, saludos desde argentina
@MrTobiascollins
2 жыл бұрын
So, I watched your video because I'm looking for a way to simplify our inventory every year. I have everything already loaded into excel as far as inventory including quantity and pricing. If I use this scanner, do you think it will also allow Excel to automatically calculate the pricing (sum) without me having to do it manually? Right now I have to edit the quantities every year one by one and it automatically calculates the sum. I'm just looking for a way to simplify this process. So, I guess what I'm wondering is if Excel will still be able to calculate the totals automatically or if I will need a separate inventory software to do this. Any help is appreciated.
@Periklisz
5 жыл бұрын
Can we do that in an android mobile or tablet? I can't find the subotal function in the android excel
@pramodmaddi6720
4 жыл бұрын
How to turn on the auto scroll down function, because everytime I used enter button, please reply asap
@Dark_Knightro
3 жыл бұрын
Lol “please reply ASAP”.
@bam4pro
6 жыл бұрын
Hello, when you scan a code, the reader sends a CR + LF, Excel populates the cell and passes to the cell below. Which parameter should I activate, because the cursor remains at the end of the code, it does not go to the next cell, neither to the right nor below. thank you, bernard in France
@karar_mhmad50
4 ай бұрын
I love you bro
@mttpo2510
2 жыл бұрын
Thanks for sharing. Have you any ide why, when my Zebr MC3300 is paired with BT does not send the information to the excel sheet opened. I getting crazy :) Any help is appreciated
@Poscatch
2 жыл бұрын
Be sure that your portable data terminal is set to transmit in keyboard emulation mode. Verify that the cursor is in the cell where you want to input the scanned data; wherever the blinking cursor is at on your screen is where the scanned data will go. You can also test this by opening Notepad and attempt to scan into that. If this does not resolve the situation, then contact Zebra tech support for additional assistance.
@kidstuffsale
4 жыл бұрын
This is great! I need to capture barcodes and get a total of codes as each is unique. Is there an easy way to set this up to do that - I don't need the subtotal as each are unique.
@thuggy67
Жыл бұрын
If my items comes with a barcode How to add it to the ssytem
@randyb3347
3 жыл бұрын
THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
@saqib7965
7 жыл бұрын
I was put forward for a role within the Processing area which will consist of data inputting, unpack aging, repackaging, use of handheld scanning guns, manual stock movement. Is this the data inputting part? First time warehouse work.
@Poscatch
7 жыл бұрын
Hello, yes, In N. America retail products have a UPC barcode and in Europe and other regions they have an EAN barcode. These barcodes are unique product identifiers for specific products. However, there are many other types of barcodes. Code 128 can contain a lot of information and is often used for logistics and asset tracking. But no matter what the barcode is on or its type, the functionality doesn’t change… and that is to track an item accurately.
@hesamwax
6 жыл бұрын
POSCatch.com
@nathanielmontgomerysr.1227
6 жыл бұрын
The count for other barcodes are not correct. How do I make sure when I scan in a barcode they will automatically be counted under the same barcode. My reason for asking is, I scanned in three different barcodes, just one of them show a how count, the rest displays, a count of 1. Can you help point me in the right direction? Thanks a million.
@SKGOELDELHI
2 жыл бұрын
how to use barcode if it is duplicate ( for duplicate it should sound )
@austinsemeta
6 жыл бұрын
Is there a system that can do count while recording what time it was scanned too?
@CrowJam
4 жыл бұрын
Just use VBA in excel, heres some leads. First) This scanner automatically pastes (I assume) the data it scans, detect it. stackoverflow.com/questions/12525942/how-to-detect-paste-event-in-excel Second) You can use ActiveCell in VBA and Offset to go to the cell on the right from the one scanner just wrote and then do ActiveCell.Value = Now . www.excel-easy.com/vba/date-time.html Now should return current time, so you ll have your code in one cell, and time in another next to it if to set it up like this. Of course theres other ways to do it, VBA is powerful docs.microsoft.com/en-us/office/vba/excel/concepts/cells-and-ranges/working-with-the-active-cell
@matthewlong768
2 жыл бұрын
Is there a method similar to this in Google Sheets?
@marcosmtz_11
4 жыл бұрын
How can I rest from inventory using the scanner?
@wallaceshackleton1889
4 жыл бұрын
Interesting and informative, very interesting to see how it is done in Excel. As an aside, you seem to have made a lot of people unhappy and I for one can't understand why.
@Poscatch
4 жыл бұрын
Thanks Wallace
@abuahmed2317
7 жыл бұрын
very good lesson and fine explanations, thanks for all you help Sir.
@Poscatch
7 жыл бұрын
Thank you for your feedback. Also, be sure to view some of the other video tutorials on our KZitem channel.
@raiteva86
4 жыл бұрын
THANK YOU VERY MUCH!
@bambahadur6752
6 жыл бұрын
Hello Sir, I do have one problem, when I scan the bar-code, the cell jumps to another 2 cell, like A1 to A3, but supposed to be jump into cell A2, (Excel 2013) Please need your help and Thanks in Advance.
@sweeyong7756
4 жыл бұрын
is there a limit as to how many items can be scanned?
@aiinad
7 жыл бұрын
Hello, Do you know if the barcode actually contains information about the product (in this case vitamin, brand X, product Y) or is it that the barcode needs to be assigned to each of the manufacture's database (for logistics purposes maybe) and also store's database to track inventory and assign prices?
@Poscatch
7 жыл бұрын
Hello, a UPC barcode does not contain any product data; it is simply an item identifier. You must assign what the item is into Excel as shown in the video tutorial. Or, if you are using a POS or inventory software program, you will need to add an item description to the program’s database unless the barcoded item has a certified GS1 UPC # that has been added to open distribution databases that some POS and inventory programs can pull product data from. For more details about UPC barcodes, please visit poscatch.com/upc-code-generator/ For logistics purposes you can use a Code 128 barcode and encode any combination of ASCII characters up to 128 characters into the barcode. You can create a Code 128 barcode for free here: poscatch.com/barcode-generator
@gerygg83
4 жыл бұрын
Hi! I'd like to use barcodes for a specific use, not what it was meant to be used for and maybe you can help me. Let's say you have 10 clients, and I assign to them 10 different barcodes. You also have 100 different boxes, each with a different barcode aswell. I want to be able to scan client 1 and then scan boxes 1, 2, 3, 4 and assign them to him. Then scan client 2 and assign 5, 6, 7. And so on. I cannot do this beside a computer, so maybe I can do the scanning with a cellphone and google spreadsheets. Or maybe you have a better idea. I don't need to see the results in the exact moment I'm scanning. So, my 2 questions are how I can do the scanning associating clients + boxes and how I can do this without being beside a computer. Thanks a lot!
@debik6118
3 жыл бұрын
Many questions here not answered. 😕
@normanbataille8865
6 жыл бұрын
HOw can I make in EXcel a check in and check out system and a list of user , example to assigne a device witha barcode to an user?
@Poscatch
6 жыл бұрын
Our tracking time & attendance in Excel video may help you: kzitem.info/news/bejne/tqGPqpd-jHWCZYY
@lazylifeseatscovers1757
7 жыл бұрын
We have been trying to find a solution for tracking our work orders as they go through our manufacturing process. Basically, we would like to use bar code (generated from order #) to track when the order leaves the following stages: Order Entry, Cutting, Sewing, Assembly, Shipping. Your video intrigued me because it's somewhat headed in the right direction for us. However, I would like to capture the date of the scan. And possibly need separate scanner set up for each stage. Thoughts or recommendations?
@nsh9051
8 ай бұрын
I’m trying to find out the method. By any chance have you found the solution to the problem?
@yesseniagonzalez4993
7 жыл бұрын
Is there any video you could suggest for an inventory that isn't a count. I need to use excel to track individual barcodes against a printed report and they are all different.
@Poscatch
7 жыл бұрын
Hello, to compare 2 different databases in Excel, you will need to program excel with a formula that will allow you to that function. Unfortunately, we do not give advice on Excel macros at this time. You could do a search on KZitem for tutorials on this topic.
@SteveChalom
7 жыл бұрын
Hi there, and thanks for the great vid. I have been tasked with taking on stock items specifically old comic books. There are 1000;s of items, and I have to capture all details (eg isbn,title,price) is there a way to scan these directly into excel, or do i need POS software? thanks
@Poscatch
7 жыл бұрын
Hi Steve, sounds like you will need a complete inventory solution. You have way too many products and product identifiers to track in Excel efficiently. We have some great complete inventory solutions. You can check them out here: poscatch.com/inventory-tracking-solutions/
@SteveChalom
7 жыл бұрын
thanks. much appreciated :)
@likemediaproduction
6 жыл бұрын
If I have 3 different products can I use 1 barcode and just Duplicated for that one item and just buy two others for the remaining did too and duplicate for all the products that are the same
@Poscatch
6 жыл бұрын
Different items must have different/unique barcodes for accurate identification.
@Mercymerc777
3 жыл бұрын
can it scan a tracking number? I need to upload a bunch of usps tracking.
@Poscatch
3 жыл бұрын
Yes, you can do that.
@brendathompson9775
4 жыл бұрын
Great can I get my spreadsheet back from COSTCO?
@nicovwln7184
5 жыл бұрын
Would excel work to setup scanning admission tickets for an event...? (No I don't want any of those ticket sales website online or cloud apps for my phone, so plz don't go into that).
@comedyvideos6233
2 жыл бұрын
Scan Karne Ke Automatic Next Line Kaise Aati Hai
@ericchan4793
4 жыл бұрын
Hey man, what kind of barcode scanner support this? Any kind also support? or dedicated barcode scanner
@hermanahdiat2566
3 жыл бұрын
Up
@brianacox2227
7 жыл бұрын
i am applying for a scanner coordinator at a grocery store. What advice can you give me so that I can be successful at it. I want to know what tools do I need, and etc
@Poscatch
7 жыл бұрын
Hello, for more information about point of sale products, please visit our blog posts at poscatch.com/blog/ and also our buying guides at poscatch.com/pos-hardware-buying-guides/.
@rosasprings9029
3 жыл бұрын
is there a way to use your phone as the scanner instead of buying one. This video was posted a little over 4 years ago and would like to know if there is a better system in place now? or any better apps or sites for small business.
@Poscatch
3 жыл бұрын
There are phone apps now (and also 4 years ago) that can perform this functionality; however, there is usually a fee associated with them, and they can be cumbersome to use because a phone's camera is not ideal for frequent barcode scanning. A way around that is to purchase a Bluetooth mobile scanner; a good one will cost $150+. That said, this video was created specifically as a tutorial to show how one can for free do basic barcode tracking of items in MS Excel. POSCatch does offer phone barcode apps, nor do we recommend any at this time. For a more advanced tracking solution for business, check out the AML LDX10 Mobile Batch CCD Scanner: poscatch.com/aml-ldx10-mobile-batch-ccd-scanner/
@rosasprings9029
3 жыл бұрын
Thank you for the information! Appreciate all the knowledge and you time !!!
@ddudhat8
9 ай бұрын
How to setup?
@Sir_Saul
7 жыл бұрын
interesting information, what if you wanted to scan the price tag along the barcode
@Poscatch
7 жыл бұрын
Hello, that can only be possible if you encode the price into a barcode, but unfortunately UPC barcodes do not include a product’s price. If you wanted to scan a product’s price and description, then a Code 39 or 128 barcode would work. A UPC barcode is generally only used as a product identifier.
@nicksilny2101
4 жыл бұрын
Hey! How to delete inventory using bar code scanner?
@Poscatch
4 жыл бұрын
If you are using Excel, you can have IN and OUT columns to track inventory, or you can purchase an inventory control program.
@JenniferR411
6 жыл бұрын
This is a great video, but how come when I use my barcode scanner, it enters into say exp A2 it uses the formula, not the actual barcode #
@Poscatch
6 жыл бұрын
Ensure your barcode scanner is functioning properly by test scanning into Notepad or some other similar application. Also, re-check your Excel formula.
@kidsafeevolutionhomedojo8410
6 жыл бұрын
Can anyone point me in the direction of doing this for not only a roster of kids but also inventory for a martial arts school?
@Poscatch
6 жыл бұрын
Our tracking time & attendance in Excel video may help you: kzitem.info/news/bejne/tqGPqpd-jHWCZYY
@आफ्नैतालमाके.यस.गोरखाली
6 жыл бұрын
U don t upload the video how these barcode delete process. Because i m in problem like this
@mikeperkins392
4 жыл бұрын
Kumar Shrestha q--
@LesLey2LUV
7 жыл бұрын
Hello, Does it only scan barcodes or can it scan serial numbers as well?
@Poscatch
7 жыл бұрын
Hello, UPC barcodes are generally not used for tracking serial numbers. If you want to track serial numbers for logistics, then it is best to use a Code 39 (up to 39 ASCII characters) or Code 128 (up to 128 ASCII characters) barcode types. You can create these barcode types for free at this link: poscatch.com/barcode-generator. You can use the same methods as shown in the tutorial video to track Code 39 or Code 128 serial number barcodes in Excel.
@Mitchief
7 жыл бұрын
hi, how do u add more (same) items, having the same barcodes?
@Poscatch
7 жыл бұрын
Hello, if you have more than one item with the same barcode, then you still need to scan each item in, or you can manually adjust the count total.
@randyb3347
3 жыл бұрын
@@Poscatch How do I manually adjust? I don't want to scan 100 barcodes of the same item, I just want my subtotal for that barcode to say 100. I tried changing the formula in the spreadsheet (no worky). Or do I have to go into the main/raw data and copy/paste 100 barcodes in the spreadsheet?
@sonnyjaxgang6675
4 жыл бұрын
How far can you be away from the company
@ecma3577
7 жыл бұрын
thank you for the video, Do you know how can I modify the scroll on the scan? I need to move to the next column either row. Help please!!! I though to do it by VB on excel but I don't have the code. thanks
@Poscatch
7 жыл бұрын
Hello, at this time we do not provide additional Excel macros other than the one supplied in the video.
@JenniferR411
6 жыл бұрын
When i scan my barcode scanner over barcode, the 0 that comes at beginning of UPC dissapeared in the cell, what do i do
@fredysjafredy1996
4 жыл бұрын
format cells into 'text' before you scan
@vishalkchoudhary674
6 жыл бұрын
You make the super video I like it video
@selvakumarmgr
5 жыл бұрын
thank you so much boss
@muhammadhammad4786
7 жыл бұрын
In our inventory we have a scanning sheet on which gives the type, name, size, color and code of the product on scanning. How are we getting it?
Пікірлер: 203