Copy row if column P contains text

[Sj3000]

Hello,

I am trying to use VBA to have excel automatically copy whole rows from one workbook to another if column P contains any text. Unfortunately I am not very good at this, I got it to work once after searching this forum and tinkering a little but now I cannot get anything.

Basically I have a workbook which contains information about meetings attended. The name of the person attending is recorded in column O and in column P is the name of who else is attending (if anyone). I was hoping to make a new workbook that would automatically compile those meetings that were attended by two staff without me having to copy them across as I do now. The problem is that this information is split into different spreadsheets by month so I am not sure it will be possible.

I would really appreciate any help!

Let me know if you need any more info.

Thanks,

Sam

[JOHN H. DAVIS]

It would be best too attach a sample with some data.

Does this help?

Please Login or Register  to view this content.

[JOHN H. DAVIS]

It would be best too attach a sample with some data.

Does this help?

Please Login or Register  to view this content.