Hello. I am not sure if I am posting this in the right place, but hope that someone can assist and direct me if not.

What I want to do is take information from a main sheet and pull certain rows (determined based up on the selection made in the delivered to column) and move it to a worksheet that contains information only for that individual entity. Below is the list of headers in my lis of all information

Ticket # Date Delivered To Net kg Wt Tons RunningTotal Daily Total

As I said, depending upon the name in the delivered to, I would like to carry forward the following information only for the specified vendor. For example if we have 3 entries 1 delivered to company a, 1 to company b and 1 to company c, each would carry forward to the respective worksheet for that vendor.

Ticket # Date Delivered To Tons

I have no idea how I might accomplish this in a usable format for what I am trying to do. Any insight on how or if this can be accomplished would be AWESOME!

Thank you~!

mary