f00tpriint
New Member
- Joined
- Aug 30, 2018
- Messages
- 4
Hey together, unfortunately I'm a complete VBA beginner trying to figure out a way to do the following:
I would like have a Workbook "Analyze" in which I press a button and then start the process:
1. Ask me to input a "Part number"
2. Lookup this Part Number in all the excel files (approx. 20) located in a specific folder (which is also the folder where the makro file is located)
3. Once it has found the Value, copy the entire row to the Workbook "Analyze" - so I end up having the Part Number and all the values of its row from every excel file underneath each other
Done.
Anyone able to help me with this?
Thanks in advance!
I would like have a Workbook "Analyze" in which I press a button and then start the process:
1. Ask me to input a "Part number"
2. Lookup this Part Number in all the excel files (approx. 20) located in a specific folder (which is also the folder where the makro file is located)
3. Once it has found the Value, copy the entire row to the Workbook "Analyze" - so I end up having the Part Number and all the values of its row from every excel file underneath each other
Done.
Anyone able to help me with this?
Thanks in advance!