I was wondering if you'd be able to help me.

I manage the Activity Summary Reports that are submitted by our Sales Staff each week. I've created these ASR reports that they fill out using Excel. There are multiple worksheets in each report. They are, COVER, SUN, MON, TUES, etc. In each of the weekday sheets, there are four columns, TIME (C13:C38), ACCOUNT (E13:E38), ACTIVITY (G13:G38), COMMENT (J13:J38). Then there are 26 rows that go from 6:30AM to 7PM in 1/2 hour increments. In the ACTIVITY column and COMMENT column, there is drop down menus that they can select from. Options include, New Account, Sample, Prospect, Etc.

I'd like to create a master file (separate workbook) that says, for each salesperson's report (like 10 of them submitted each week) if Column ACTIVITY equals PROSPECT, Display the ACCOUNT Name and the COMMENT along with the Salesperson Number and the date of the report.

I want to end up with one excel file each week that outlines all of the prospects performed by our sales staff that particular week.

The closest example I could find was in this thread. I was wondering if you would be able to help me alter the code to do what I need it to do?

I know this is a lot to ask, but maybe you could point me in the right direction? If I should submit more information or if I should start a new thread, please let me know.

Thanks, Jason