SharmaAntriksh
New Member
- Joined
- Nov 8, 2017
- Messages
- 31
Employee Name | Client Name | Assigned on | Due Date | Actual Delivered Date |
Antriksh Sharma | xyz | 7/2/2018 | 7/4/2018 | 7/5/2018 |
Monique | abc | 6/7/2018 | 6/22/2018 | 6/19/2018 |
Antriksh Sharma | edf | 6/3/2018 | 6/5/2018 | 6/5/2018 |
Monique | mnb | 5/3/2018 | 5/20/2018 | 5/21/2018 |
<tbody>
</tbody>
I have as huge database that looks similar to the above table, and i have a lookup table where i have the client names, i am trying to create VBA code which can help me in quickly extracting data from the above table if it matches my lookup table, i tried "For Each" loop but that evaluates again and again and is really slow, can you help me with some thoughts or code on how to make this process efficient?