Printing on condtion in message box?

Does anyone know how to print when a certain condition is present in a message box e.g if my msgbox has text and value like....Bloggs J has 17 days booked off, is it possible to have some code that then finds all instances of that name in any column greater than row13 and also select the corresponding offset from column A paste them in to a workbook then print them off as 2 columns (if it can be done with out pasting in to a workbook even better!) so effectively it would look like this:-

12/2/05 Bloggs J
22/3/05 Bloggs J
4/7/05 Bloggs J

etc.?

Hope you can help,

Simon

Sorry for the repost just trying to catch people who are online a different time for some help!

Simon