Hi all,

I'm new to vba and trying hard to learn the coding but struggling.

I would like to export data and the corresponding rows based on a value in another cell and then save this as a new workbook.

The criteria would be "yes" and then copy that entire row. In this exercise there would be several rows with the criteria "yes".

The new workbook would then be used in a mail merge function. IF there is a code I can use to automatically create the mail merged pdf that would be great and any insight would be greatly appreciated.

I hope I've given enough information and if not, please let me know!

Thanks in advance