This excel doc is sent to me every week (like it is) and I have been "long-hand" copying the data to new worksheets; deleting the branches that I don't need on that worksheet; renaming the worksheet to match the branch; then once I have a worksheet for each branch, I insert a module that breaks the worksheets into individual documents. I was hoping to find an easier way to break up the data into the different worksheets, instead of the long-hand way.