Hi friends! Looking for some help here with formulas (trying to do this without VBA); I've done something similar years ago and can't remember how I did it! I am working on a sales tracking workbook. I have Zapier dumping raw data into the workbook from my transaction database and am filtering the data from there. I have a list of sales reps and their respective transaction on the data dump page. I would like to have each respective rep's sales automatically generated into their own page within the workbook.
Column A of the data dump page contains the reps' names, and Columns C thru Q contain the sales details for each transaction. I need some sort of lookup function on each rep's page in the workbook that pulls only their sales.
For instance, this is what the beginning of a row in the data dump page looks like:
<tbody>
</tbody>
Any help would be appreciated, please and thanks!
Column A of the data dump page contains the reps' names, and Columns C thru Q contain the sales details for each transaction. I need some sort of lookup function on each rep's page in the workbook that pulls only their sales.
For instance, this is what the beginning of a row in the data dump page looks like:
Rep | Client | Contact | Time | Sale | Units | Recurring |
Sally | ABC Inc. | Mike Jones | 10am | $2mm | 16,500 | No |
<tbody>
</tbody>
Any help would be appreciated, please and thanks!