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!