Mark,
Send me the workbook.
I will write a macro for you

meanwhile do autofilter, copy and paste the filtered data to the relevant
sheet with macro recorder on.
Cecil

"Mark" wrote in message
om...
Who can help me with the following?:


I have 12 Spreadsheets for each month of the year.
Each Spreadsheet contains the column, 'Agent Number'. Entered into
this column is a 3 digit number, ie Agent Jones is number 150.

I also have a seperate Spreadsheet for each agent.
What I would like to do is search the 'Agent Number' column for each
of the 12 Spreadsheets and then copy certain columns into the relevant
Spreadsheet.

For example,

1. Search Spreadsheets Jan-Dec for agent number 150
2. Copy columns B,C,D,G,J from the row containing 150
3. Paste that information into the Spreadsheet for agent Jones

Is this possible?

Many Thanks

Mark