Get instant live Excel expert help to learn how to use Search function in Excel?

Previously, someone created a macro that automatically highlights the cell that I search in the macro. For example, when I search a barcode, it would highlight the corresponding barcode in excel. I used this for scanning barcodes with a barcode scanner and seeing if my excel spread sheet has that barcode. The macro works exactly how I want it to work, but it doesn't work in rapid succession. Im scanning hundreds of barcodes, and I can't run the macro each time I want to scan a barcode.

Summary: Is it possible to run a macro in rapid succession? Previously, someone created a macro that automatically highlights the cell that I search in the macro. For example, when I search a barcode, it would highlight the corresponding barcode in excel. I used this for scanning barcodes with a barcode scanner and seeing if my excel spread sheet has that barcode. The macro works exactly how I want it to work, but it doesn't work in rapid succession. Im scanning hundreds of barcodes, and I can't run the macro each time I want to scan a barcode.

I'm trying to create a IF Search combination that includes a VLookup. I can get it to return the true result, but cannot get it to return the false result.

I am trying to create a search type thing that compares three different values to three different columns. What would be the best way to do it in vba?

I need a formula in Cell F2 to check cell E2, if it has information, Check Cell B2, If that has a number greater than 1000, Search the B Column for a repeat. If there is a repeat, populate Cell F2 with the current time and date.

Hi, I need a formula that would allow me to search for a number and question within adjacent rows to show the text in the next column. So to basically sort through a list of data inputs to create a table on another sheet

I need a formula to select a cell value based on what I enter in another cell. For instance, if have a long list, and I want to recall "A34891", I want to enter "A34891" in one cell, and it is used as a search for cell A34891, and displays its information.

I have an excel spreadsheet full of personal data on my contacts (i.e. name, address, phone number, email address, etc.). Each of these are broken out into columns. The problem is, some columns have the wrong information in them. For instance, I have a few columns that have someone's email address in a column that calls for their phone number. Is there a formula I can use to search an entire column and then extract the email address from that column and move that data to another column (but on the same row)

Hi, I would like to ask your advice regarding one more complicated formula. I have a master sheet containing hundreds of lines of data and I am creating an overview - new sheet with linked data. I would like to form a formula that can find specific text in a row - 2 key words /2columns - country and position-and if positive, copy one cell - email - to my overview sheet . I have tried multiple if, isnumber, excel search function but no having success.. can you help? does it make sense?

I would like to put in or search for a date within one worksheet and then for that data to be extracted in the main Master Daily Production worksheet.