Selecting rows in a table based on another list

Originally Posted by :) Sixthsense :)

Not seeing anything in sheet2. Can you please where is the list appears in sheet2? and also show the expected result for better understanding

Hi, I just updated the excel sample sheet. Thanks for the quick response.

Hi,
So the code that you provided above basically selected only those rows from the table whose names matched with the list on sheet 2. I can work with that as well, thank you so much. But being a total noob with macros and VBA solutions, I was wondering how would I apply/replicate the code/VBA solution to my actual dataset?

Originally Posted by :) Sixthsense :)

Yes exactly

If your data source is also same like your example file then just follow the below link to know how to add the code in your file.

http://www.contextures.com/xlvba01.html

Otherwise just show the format of your data so that slight changes can be done according to your source data.

I'll try to work with this and get back to you if it works out. Thanks for providing this useful link. I however didn't understand what you meant by "show the format of your data".

Originally Posted by :) Sixthsense :)

show the format of your data is meant for the column / row references and sheet names of the data.

It worked beautifully sixthsense. Thank you once again. But since my dataset is quite large, it took an awful amount of time just to get through one quarter of my list. But I have saved to code for future reference.