I have multiple excel files (one for each type of contract), but I need
to submit a report listing all active contracts by parter company (plus
the names of each contract manager, the value, etc). Each partner
company has a code it is identified by, and I am looking for a way to
extract the info based on these codes. I am familiar with macros but not
programming. Is there a simple way to do this?