conditional transfer of rows to other sheets based on cell content of 2 colums

Hello,

I am working on a production worksheet. Sheet1 is called "Lead Input" and contains columns of names, addresses, prices, etc. There are two columns that are important for the code that I need, columns C and F. These columns are for the assigned agent (C) and the status of the job (F).

First, I have 5 other worksheets, one for each agent. So dependent upon cell content in column C (agent names), I need that row to be copied to the specific agent's worksheet as well at the next available row once I have entered it in on Sheet1.

In addition to this, I have a worksheet for "Closed Production," and I need all rows with the status "closed" (column F) to be copied onto that worksheet.

So I need Sheet1's content to be directed to the proper agent sheet, as well as copied over to "closed production" when that status is met.

I'm relatively new to Excel, so any help would be greatly appreciated. Thanks!

Couple of quick questions.

What are the agents names in Column C going to be(exactly)? You said there were 5.

Do you want the row deleted on sheet 1 after it has been moved to the other sheets based on column C and F criteria?

With these questions answered it shouldn't be too hard to do for you.