I have a master worksheet that contains project report information. Of
the 300+ rows of data, I need to pull only the rows based on the
"Business Owner" column into another worksheet (or workbook) so I can
send only the project information specific to that business owner. The
manual alternative is to save the workbook with another name, delete
the rows that don't pertain to that business owner, save, and send. Is
there a formula or macro I can use to automate this process? I have
25-30 different business owners and the manual process is too time
consuming.