MICROSOFT EXCEL - BOX WITH DYNAMIC SEARCH FORMULA
Budget: €30 – €250 EUR
Starting from an excel file with some sheet, there is a sheet containing the DB (price list on hundreds of goods) then we have the main sheet where we do the quote for our customers.
The goal of the project is to create a sheet, where in a space of 50 rows, the dynamic search cell is present in each row, which works like the one you see in the video. Once the desired article has been selected, the cells next to the search cell must be populated with the information found in the DB and relating to the selected article. It must also be possible to see the photograph of the selected product taken from the DB.
I will provide the excel file seen in the video.
The file provided unfortunately does not work correctly, the method I used to make it is not solid, sometimes it searches correctly, sometimes it does not, sometimes it does not search at all (as you can see in the video). Also that cell copied in the following lines does not bring correct results. I suspect it is to be taken as a starting point, but then completely redone, perhaps in VBA.
It will be useful but not indispensable for the project, within the limits of the technical possibilities, the ability after selecting the desired article, to be able to automatically move to the next search cell, or to be able to switch to it with the TAB key. This function must be able to be disabled.
The excel file provided can be completely changed and modified, the important thing is that the whole project works with a single xslm file.
The goal of the project is to create a sheet, where in a space of 50 rows, the dynamic search cell is present in each row, which works like the one you see in the video. Once the desired article has been selected, the cells next to the search cell must be populated with the information found in the DB and relating to the selected article. It must also be possible to see the photograph of the selected product taken from the DB.
I will provide the excel file seen in the video.
The file provided unfortunately does not work correctly, the method I used to make it is not solid, sometimes it searches correctly, sometimes it does not, sometimes it does not search at all (as you can see in the video). Also that cell copied in the following lines does not bring correct results. I suspect it is to be taken as a starting point, but then completely redone, perhaps in VBA.
It will be useful but not indispensable for the project, within the limits of the technical possibilities, the ability after selecting the desired article, to be able to automatically move to the next search cell, or to be able to switch to it with the TAB key. This function must be able to be disabled.
The excel file provided can be completely changed and modified, the important thing is that the whole project works with a single xslm file.