# scan

1. ### Excel SCAN function by for each column in a table

Can the Excel SCAN function work on a table a calculate a running total for each column individually. I tried the following formula: =TRANSPOSE(SCAN(0,TRANSPOSE(Table_Array),LAMBDA(a,v,a+v))) However, I get a running cum by column for the whole table, not for each column individually.
2. ### Calculating Exponential Moving Average in one cell (Scan Function?)

Hi all, I am trying to figure out how to calculate the Exponential moving average of a stock. The sheet shows the steps involved. I tried using the scan function but I couldn't figure it out. I hope someone smarter than me can help with the formula or point me in the right direction. I know I...
3. ### Reading a text file and scan for values

Good Morning how would I go about reading a text file and scan for values? If found return the header line. the text file has a header on line line (Test1) the second line has all the IP values between each group is a blank line the text file looks like this? (test.txt)...
4. ### Utilizing Dynamic Arrays for Compound Annual Growth Rate

Dear Members, I need assistance in creating a CAGR array from periodic returns vector. I wish to create a Dynamic Array holding only calculated CAGR (compound annual growth rate) values derived from periodical return on investment vector. This is easily performed in standard Excel but...
5. ### Scan Barcode...compare against inventory...place X in cell when matched...automated

<a href="https://fhexcelphotos.shutterfly.com/pictures/9" target="_blank">https://fhexcelphotos.shutterfly.com/pictures/9 https://fhexcelphotos.shutterfly.com/pictures/10 Hi All, Please bear with me as I am not a programmer and therefore aren't fully competent with the terminology or...
6. ### VBA prevent wrong item being scan

Hi, I have a cell start from C7 to C10001. The data here is between PASSED and WRONG. which i created a simple barcode scanner purpose. How i can use a VBA code to stop scanning purpose if WRONG item scanned in the cell(C7 to C10001) Also a popping error message tell that you scan a wrong item...
7. ### Simple Scanned Inventory in Excel

Hi, If this isn't appropriate, please forgive me and let me know. I have a small business and am looking for a simple solution to taking inventory at the end of my season. I would like to be able to scan barcodes to enter the info. I would also like to be able to scan an item 3 times, for...
8. ### Scan All Product Data into Excel Using the Barcode

I would like to know if this is possible. You can use Excel to scan in a Barcode from various products, it scans into a cell and either you autotab or click to the next cell to get the next barcode. When you sell a product like books you notice that certain data is consistant accross related...
9. ### Stock Control

Hi Guys I have a limited knowledge of excel, but unfortunately I have been volunteered to implement the below: I want to able to do the following: 1. scan a product in that it registers in excel 2. then scan it into the stock location area 3. then scan the quantities , I presume we have...
10. ### How to close currently opened folder?

An excel file and folders including folder "Scan" is currently opened. How to close only "Scan" by VBA?
11. ### VBA Help

Below is a sample of the current code I am using in excel to highlight cells when our products are in a box. The code worked fine until I increased the number of Rows it needed to go through. I'm not very good with loops so need some help rewriting this as a loop;so it can scan 200 rows x 7...
12. ### Find and Replace content of string using reference list

Hi all, I've searched with little luck, I'm new to excel and can't edit these VBA's by myself enough to solve. :confused: I want to scan Column A for characters or strings in column B and replace them with Column C, in this case a blank. May I have a VBA macro to scan list A2:A5000, replacing...
13. ### Ms access 2010 on a continuous form move to the next record without using enter or tab etc

Hello We have a one field continuous form that we use to scan numbers into. The problem is after each barcode is scanned the user must hit tab , enter or use the mouse to navigate to the next record. Is there a way to have it move automatically ready to receive the next scan with the user...
14. ### How to integrate a barcode scanner into excel (cells,sheet, etc.)

Hi all, I bought a bar code scanner (a cheap one for 20 €). I would like to scan the barcode of the receipts and scan only date and total amount in predetermined cells. My question, is this possible with VBA? …without any extra software or costs. And if yes, how? …. Is there...
15. ### Macro for scanning QR codes

Hi, I have a spreadsheet with a few hundred items on it and these items are occiasonally getting sent out and then returning to me and I want to to book them in and then out so I know what is happening. I currently have a tab with all of the items on it and then I have created a new tab for...
16. ### #NAME? error when scanning bar code

I have a spreadsheet that users need to use to scan in bar codes. When they try to scan the bar code the cell populates with #NAME ? The cell is formatted as General Any thoughts about what is causing this?
17. ### Current Date and time in a form when record is created

We are considering switching from MS Access to Excel for a simple (??) time logging system Using our access database, when a worker starts a new part of a job they go to the computer, grab the barcode scanner. They scan their name, the process the are embarking on (e.g Bending, or threading)...
18. ### Scan out/in System (VBA HELP NEEDED)

This is my first time posting so not sure if Iam doing this right. I want ascan out/in system for scanning items out and back in again with a time stamp,below is what I have a the moment LabelCode Time Out Time In 0615W 05/02/2019 11:00...
19. ### Change pdf files names in folder with VBA

Hello all, i have this: <tbody> A-scan B-Name Scan01 GR18987564-Plat1 Scan02 GR18987564-Plat2 Scan03 SR-85-18987654654-PL1 Scan04 SR-85-18987654654-PL2 Scan05 GT6576846465-Plat1 Scan06 GT6576846465-Plat2 Scan08 GR18987798-Plat1 GR18987798-Plat2 Scan07 GR18897-Plat1...
20. ### MACRO (Scanning 2 barcodes for each row) - Need ASAP

Good morning gurus, I have a problem that I need some assistance with. I need to be able to scan into an input box 2 variables. The first box will be a barcode scan of a serial number, and the second barcode scan will be a weight. I need for the 1st scan (Serial Number) to be in column A...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back