Hello,
I am trying to pull data from multiple worksheets in an excel workbook I have created regarding underpricing of invoices at my work.
Each worksheet is a sales reps invoices for the month. Column H is formula driven and provides a "Yes" or "No" answer of whether the invoice is underpriced or not.
What I want to do is pull all the "Yes" values for each sales rep onto one Summary tab. I want the entire row for each invoice to pull.
How do I do this? Can anyone help?
I am trying to pull data from multiple worksheets in an excel workbook I have created regarding underpricing of invoices at my work.
Each worksheet is a sales reps invoices for the month. Column H is formula driven and provides a "Yes" or "No" answer of whether the invoice is underpriced or not.
What I want to do is pull all the "Yes" values for each sales rep onto one Summary tab. I want the entire row for each invoice to pull.
How do I do this? Can anyone help?