Copy entire row to a new sheet when cell value is less than 100

**Dame** · 04-03-2012, 10:26 AM

Hi

I have looked through the forums but have been unable to find a fix for my specific problem.

I have a worksheet named "Forecast" that has numerous rows all with a "next due" column, currently column C, with a number value. What I would like to do is when the Column C value falls below 100, copy the entire row into a new worksheet named "Next Due Report".

I need to keep the original row intact.

Is there a simple macro that i could use to do this automatically for me.

Thanks for your help.

Damian

**Kelshaer** · 04-03-2012, 10:39 AM

Use this

Please Login or Register  to view this content.

**Dame** · 04-03-2012, 11:28 AM

Forgive me I am new to this, but how do i run the macro. I have added the code to my worksheet and saved it as a macro-enabled worksheet, but i am not seeing any information in the next due report?

Thanks

Damian

**Kelshaer** · 04-03-2012, 11:36 AM

press ALT + F8 then run the macro from the dialog

**Dame** · 04-05-2012, 08:12 AM

Hi I have tried this and it comes up with a "400" error from visual basic.

**Kelshaer** · 04-05-2012, 08:47 AM

this macro assumes that there is no sheet with the naem "Next Due Report". If this sheet already exists before you run the macro then it will give an error