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!”
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