Pulling data from a main sheet to subsequent sheets in a workbook

[mary012277]

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

[hoyasaxa215]

A sanitized sample template with a few examples of the data BEFORE and AFTER the change is made would be helpful. Click "Go Advanced" and then click on the paper clip icon at the top to upload an attachment.

[mary012277]

Maybe this example helps.

I manually moved the information from the first worksheet to the subsequent worksheets. I would like to be able to make a formula or somthing that does this for me to the appropriate worksheet.