I use excel to summarize weekly loads hauled by our trucks. I use the first sheet to enter all data for all loads. Then filter and copy and paste to additional sheets in order to create smaller summaries for different drivers, crews, landowners. This works okay but there must be a way to auto populate the additional sheets from the first sheet. For Example:

First sheet "Load Summary" has all load information entered.

load summary.jpg

I then need to make a separate summary with just loads that Mark hauled, on sheet "Mark". The bottom of this sheet is set up to auto calculate what to pay Mark based on what/where he hauled.

Mark Loads.jpg

I'm thinking there must be a formula to copy the row if column K matches "Mark" but I'm unsure of what it is. Depending on the week there are sometimes 150-200 loads on the "load summary" sheet. Thanks in advance.