shakethingsup
Board Regular
- Joined
- May 21, 2017
- Messages
- 64
- Office Version
- 365
- Platform
- Windows
Hi again everyone,
Q: what's the most efficient way to search for partial matches and populate results?
I'm fairly beginner at vba but learning quickly.
I have two very disorganized workbooks. Wb2 is where I will make all my edits.
Raw data 1 or wb1:
Raw data 2 or wb2:
wb1 cell I10 is similar to wb2 cell C2 because of the J1 - the unique identifier is J1 which is also buried in string. There could be J1 to J100 so I'm sure I could use a loop at some point.
Output: In Cell F2 in wb2, I want to pull L10 from wb1 i.e. F2 wb1 = $5
1. I've learned about the instr function in vba
2. I've learned how to open workbooks so from wb1 I open wb2
3. I'm getting better at loops
Q: what's the most efficient way to search for partial matches (in this case "J1") and populate results?
thank you!
Q: what's the most efficient way to search for partial matches and populate results?
I'm fairly beginner at vba but learning quickly.
I have two very disorganized workbooks. Wb2 is where I will make all my edits.
- each workbook when exported has varying lines of code.
- each are downloaded from two different systems and so the raw data looks like this:
Raw data 1 or wb1:

Raw data 2 or wb2:

wb1 cell I10 is similar to wb2 cell C2 because of the J1 - the unique identifier is J1 which is also buried in string. There could be J1 to J100 so I'm sure I could use a loop at some point.
Output: In Cell F2 in wb2, I want to pull L10 from wb1 i.e. F2 wb1 = $5
1. I've learned about the instr function in vba
2. I've learned how to open workbooks so from wb1 I open wb2
3. I'm getting better at loops
Q: what's the most efficient way to search for partial matches (in this case "J1") and populate results?
thank you!