Bean Machine
Member
- Local time
- Today, 10:14
- Joined
- Feb 6, 2020
- Messages
- 102
Hi all,
I am back again to ask a bit of a long winded question that I hope I can word correctly. Essentially, I need VBA code that checks cell A2 in worksheet Driver to see what worksheet to analyze, then checks cell C2 and finds a column match in the worksheet described in cell A2 THEN I need the code to check range D2: D10 and for any non-empty cell check range A:A in the worksheet described in cell A2 and for any matches in that range find the intersecting value between the match in A:A and the matched column and paste then match values in range E2:E10. The images below should help a lot in describing what I am saying haha.
Driver worksheet
Testing worksheet
I am back again to ask a bit of a long winded question that I hope I can word correctly. Essentially, I need VBA code that checks cell A2 in worksheet Driver to see what worksheet to analyze, then checks cell C2 and finds a column match in the worksheet described in cell A2 THEN I need the code to check range D2: D10 and for any non-empty cell check range A:A in the worksheet described in cell A2 and for any matches in that range find the intersecting value between the match in A:A and the matched column and paste then match values in range E2:E10. The images below should help a lot in describing what I am saying haha.
Driver worksheet
Testing worksheet
