kuroshfly3424
New Member
- Joined
- Feb 20, 2014
- Messages
- 2
First, I'm really a rare user of Excel. And now, I need to 'develop' with it.
So, basically, I have this form in a workbook (as the first sheet). This form have the folder destination (of which the CSV files are located), the value to search for (say, a unit name), and a button. The folder destination and the value to be searched can be changed according to what the user input in the form.
When the user press the button, the macro will run, and a few of the characteristics of the matching unit in the CSV will be displayed in the next sheet of the workbook.
I have an idea of using the column to search and retrieve the value from the CSV. For example, the value to be searched for all located in the B column of the CSV, while the values need to be retrieve are in C and F respectively.
So, can anyone help me with this? I'm currently doing my research and studies on it since I'm fairly new to this language.
So, basically, I have this form in a workbook (as the first sheet). This form have the folder destination (of which the CSV files are located), the value to search for (say, a unit name), and a button. The folder destination and the value to be searched can be changed according to what the user input in the form.
When the user press the button, the macro will run, and a few of the characteristics of the matching unit in the CSV will be displayed in the next sheet of the workbook.
I have an idea of using the column to search and retrieve the value from the CSV. For example, the value to be searched for all located in the B column of the CSV, while the values need to be retrieve are in C and F respectively.
So, can anyone help me with this? I'm currently doing my research and studies on it since I'm fairly new to this language.