I need a software to do THREE key-numbers to be searched in specific column of Excel File.
Visual Interface of software will have following main elements:
1) Browse button: To take to the certain default folder. And allows user to select Excel file.
2) Once file is selected, it will come back to the user interface. Further there will be three input boxes.
3) In each input box user will type in number e.g. 2510, 200, 15, etc.
4) After entering all three numbers, user will press SEARCH button.
5) Now software will search for these numbers in selected Excel file in specific column.
6) after searching, software will make new Excel file in which all entries from original Excel file are re-arranged which has any or all of these three numbers. Rest of the rows in excel file are reported last.
7) Need to add counter on how many times files have been selected and searched.
8) Need this software to be used as web based application.
This is simple search engine application for Excel file. Further small customisations are required in Excel file newly generated which I will discuss one to one.
Bu iş için 13 freelancer ortalamada ₹7923 teklif veriyor
Hi, I am well versed with Excel macro and automation in Excel and can help to build the search functionality. It would help if you can share the Excel sheet you are having. Looking forward to your response. Thanks
As an expert in VB scripting and Excel VBA, I feel that i can deliver this on time and error free. Will make sure that the employer is satisfied.