Plus, it's so much better when you can keep going cercare without having to enter the command over and over in Excel.
This makes your job a lot easier, so it's a relief that this spreadsheet has features that help you find any data faster.
VBA macro
The methods for carrying out a continuous search require a certain " Programming »Which can only be understood by reading the Excel workbook.
Or, you could take a content course, which can be done at the following link, where they have a whole library of material.
This will help you program or code in the VBA to build and create a macro that will allow you to use intelligent search methods. VBA is an object-oriented programming language in Excel, whose acronym stands for Visual Basic for Application, which has many uses and properties.
So, to access it, within the program you have to go to the " Developer «, Action that will unlock a series of choices.
On the left side of that segment, there will be an option called " Visual basic Which must be clicked to continue.
There, a new window will open within the same spreadsheet, in which there will be a left position element and a blank screen.
To continue you have to choose the file or the name of the document from the above bar, and in the empty part in the center write the macro.
In this place you can build the code you need depending on the case, or it can be taken from a sample model from the Internet.
Provided that you need to make sure that the example found meets the user's needs, so that there are no errors.
Use the Find method only
In this part of the guide, you will only run the Find method before setting up and running a continuous search in Excel.
Once you have adjusted the macro within the VBA spreadsheet, you will be able to proceed with the simpler procedure.
That's when you have to go back to the file " Developer »And identify a button with the name» Macro «.
Clicking on it will display a list of all items of this nature added to the existing spreadsheet.
Since there is only one in this case, that's the one to choose and click » Run «, Which will show a box where you can write. This way, you write down anything that can help you identify the value you want to find in Excel.
This can generate a series of reactions, which will depend on the macro configuration that has been placed on the sheet. In most cases it results in the underlined value of a specific color.
Use the FindNext method to perform a continuous search
Therefore, by means of this technique, it will be possible to carry out a continuous search already performed with the previous method.
This way, when the macro is used, you will allow you to underline or select other values which may have a match with the former and the search suggestion.
It does this by saving the first choice or result found and, through a loop, continues to find more values.
To do this, you have to return to the VBA editor and slightly modify the structure of the macro used to create the first support.
Inside it must be placed a conditional that says that as long as the value is similar to another, it must be taken in the same way. And another that makes the cycle non-continuous, and that the moment comes when, when there are no more coincidences, it must stop.
Macros can be used in Excel for anything you want, whether it's for a simple task like copying and pasting cells or a more complex one like searching for words in a range or range of cells.
