Get instant live expert help on I need help with excel search macro

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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.
Solved by M. U. in 16 mins
I need a formula or macro that will display only matches of a search.
Solved by B. U. in 22 mins
Cannot use a macro to insert the formula =SUM(=LEFT(T25, SEARCH("x",T25,1)-1))"
Solved by E. F. in 28 mins
Range("B9").Formula = "=SUM(=LEFT(T25, SEARCH("x",T25,1)-1))" Having trouble insert this formula into a cell via a macro
Solved by B. J. in 30 mins
I am having a problem with the filter in excel. When I search for a value in the search box, I am seeing two of the same entry in the search results. I should be only seeing one.
Solved by T. S. in 23 mins