How can I extract rows matching some criteria to different sheet?
Pivot table requires summarizing data by I just want the raw data from the main sheet.
Filter only works in the current sheet and requires user to specify filter criteria.
vlookup requires a formula for each row but how do I know how many rows will be selected
For example:
The main "Data" sheet contains:
salesperson product qty saledate
Bob ddr3 10 12-mar-17
Bill ddr4 2 1-apr-16
Jane ddr 11 14-may-16
Bob rambus 44 23-jun-16
I would like to create a sheet for each salesperson (can be static)
"Bob" sheet:
ddr3 10 12-mar-17
rambus 44 23-jun-16
"Bill" sheet:
ddr4 2 1-apr-16
So, all the salesperson has to do is click on the tab corresponding to his sheet to view his sales.
Bookmarks