Tks to both.

Both ways are workable. Problem is that each time I update the information,
have to re-write the formulas, and copy paste to 40 diferent worksheets.
Is there a way to, when sheet 1 is updated, all others are automaticaly
updated also??

"Antonio" wrote:

> Hi all
>
> Need help for the following:
>
> Have a worksheet with 3000 rows by 7 columns, filled with numbers that range
> from 1 to 3000. Need a way to move a row to a different worksheet if the
> number in one specific cell is either odd or even
>
> Can anyone help?
>
> Tks in advance
>