Hi all,
Long time since I've been on here! I am currently working on a project. Apologies for not providing much information but due to the nature of the project i can't disclose everything. There are over 10,000 records in this worksheet! There are also > 90 columns of data for each entry.
The first colum is an ID number - there can be multiple rows of information for each ID number (i.e. the same number can appear 2-4 times).
I have isolated a list of ID numbers I am interested in - these have been copied to another sheet for ease of use.
I wish to isolate all rows of data associated with these ID numbers - i.e. have all rows for the first ID number in my series, followed by the second number in my list and so on - and essentially ignoring the entries that I do not want.
I'm not sure if I have explained this wll at all so have included an example workbook - I want to copy all rows of data corresponding to the ID numbers on sheet 2.
Thanks for all the help in advance!
J
Bookmarks