code to copy row and sheets to different workbook.

[coxycoxycoxy]

Hi all

can anyone help with the following:

I need to construct a piece of code to do the following.

search column "I" in sheet named "CONTROL.SHEET" for zero values.
if column "I" has a zero value paste that entire row to a different workbook. called "ZERO STOCK ITEMS" SHEET. STARTING IN "B4".

Here is the catch i also need it to copy the work sheet named in column "C" of the zero valued row. all the names in column "C" match the worksheet names.

I Hope some one can help

Best regards.

Mark