Hi everyone,

I have an excel document with 2500 rows and columns A-J.

I have 650 IDs/Names in a text file. Those IDs are listed in the 2500 rows for each, under the C column.

I would like to extract those 650 lines and insert them in to a separate sheet. Instead of doing a control find and cutting each and every one, I was wondering if theirs an automated way to do this? For eg, if I have ID "kramer" in my text file, when I do a control find, I find it on row 50. I need that entire row copied and extracted in to a new sheet. I need this done for them all. I'm not an excel guru or expert, looking for some help.

Thanks!