Every quarter, I have to do bonus statements for our sales rep. Part of that includes giving them the detail that make up their sales for the quarter. I have a master spreadsheet that contains all of the information for all of the reps. Normally I filter that for each rep, copy and paste their sales into their spreadsheet. Is there a way, in their spreadsheet, to write something that will pull their information from the master so I don't have to filter, copy, and paste for 45 different reps?