Extracting data that meets certain criteria from the lookup table

[SharmaAntriksh]

[TABLE="width: 600"]
<tbody>[TR]
[TD]Employee Name[/TD]
[TD]Client Name[/TD]
[TD]Assigned on[/TD]
[TD]Due Date[/TD]
[TD]Actual Delivered Date[/TD]
[/TR]
[TR]
[TD]Antriksh Sharma[/TD]
[TD]xyz[/TD]
[TD]7/2/2018[/TD]
[TD]7/4/2018[/TD]
[TD]7/5/2018[/TD]
[/TR]
[TR]
[TD]Monique[/TD]
[TD]abc[/TD]
[TD]6/7/2018[/TD]
[TD]6/22/2018[/TD]
[TD]6/19/2018[/TD]
[/TR]
[TR]
[TD]Antriksh Sharma[/TD]
[TD]edf[/TD]
[TD]6/3/2018[/TD]
[TD]6/5/2018[/TD]
[TD]6/5/2018[/TD]
[/TR]
[TR]
[TD]Monique[/TD]
[TD]mnb[/TD]
[TD]5/3/2018[/TD]
[TD]5/20/2018[/TD]
[TD]5/21/2018[/TD]
[/TR]
</tbody>[/TABLE]

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?

 

[mumps]

Can you post a screen shot of what your lookup table looks like? Section B at this link has instructions on how to post a screen shot: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html Alternately, you could upload a copy of your file to a free site such as www.box.com. or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells and worksheets. If the workbook contains confidential information, you could replace it with generic data.

 

[SharmaAntriksh]

Lookup table will only contain the unique client names only and those name are amongst the ones listed in the above table, i can't share the file due HIPPA and PHI regulation.

 

[mumps]

Without knowing what your lookup table looks like, it will be very hard to help you. When you say

extracting data from the above table if it matches my lookup table

we don't know how it should match, what data to extract and where to place the extracted data. Can you manually create a mockup workbook with generic data that would reflect what your sheets look like?

 

[SharmaAntriksh]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Client Name[/TD]
[/TR]
[TR]
[TD]xyz[/TD]
[/TR]
[TR]
[TD]abc[/TD]
[/TR]
</tbody>[/TABLE]

The lookup table looks like this and i would need extract the whole row of data from my Data/Fact table, i hope this helps.

 

[Joyner]

Hello, it sounds like you are confusing the terminology and calling your list of names the lookup table and from what you have described I believe those are your lookup values and your "huge database" is actually your lookup table.

You mention you tried a loop in VBA, do you care to share what you have done - that may help everyone help you.

Also, have you tried an Advance Filter? That will do what you want quickly, or you can use that in your code versus the loop method.