I have a data sheet that holds a lot of information including address info. Say I have a column labeled "Mail?" and one can choose Yes or No. I want them to be able to choose Yes on several rows and have another sheet pull the address info for those rows only.

Then my goal is to use that address sheet to either format it into an avery 5160 template for the labels or what would probably be better is have a mail merge into the avery template and the user can move the data where they need to print to the next available label on the sheet.

Any example sheets would be nice. I can then pull the code out and make sure it syncs up with my sheet name, criteria, range, ect.

Thanks for any help or assistance in a solution to making labels auto-populate for multiple data rows.