Linking Data from one Workbook to Another Workbook

[Nuclearman83]

I have a program that I am require to use that outputs data horribly and makes it very hard to see the big picture for where everyone is for their certifications. I output everything into a CSV (only way I can) (Qualifications). I am trying to get the data to look more presentable so I can see the big picture. The CSV is 66,000 lines of data that I to filter into everyone's certification so that I can see who has what and who needs what. My issue is that I filter the CSV and copy and paste the list of names for each certification from the CSV to my worksheet (Input). I now can manipulate it so that it has an easy to see status of all 4000+ employees.

=IF(AND(Qualifications!$A1="43426-9",Qualifications!$B1=309),Qualifications!$D1,"")

Is there a better way to do this?

Sorry if I am posting this in the wrong format.

 

[offthelip]

Writing a bit of VBA to do all the filtering and copying and pasting into a new workbook is the way I would do that. VBA is particularly good at sorting out the problems of data that is presented horribly

 

[Nuclearman83]

VBA always kicks my butt, I consider myself pretty decent at Excel but VBA is my Kryptonite.