I have a project that i need help on. I have a workbook of spreadsheets that is used to keep track of sales made and commission based on those sales. Because my accounting department needs special help...I need a way to export the data within a given area, based on a "yes" to pay cell. So if the cell is "yes" the data is exported, if the cell is "no" the data is not exported.

I am thinking about coding this into a button, but i am open to other suggestions first.