I have a spreadsheet with 20K rows. I need to select the employee ID and the
respective rows of data from the spreadsheet and put it into another
worksheet. Example, the employee is C123456 and I want all the rows of data
where his ID is referencend in a particular column. I tried vlookup, match,
index but have had no luck with these. This is a process we'll be running
monthly which basically tracks no of tickets an employee handles in that
period. Any suggestions are appreciated. Thanks.