Hi Ken

Then I am doing something wrong......
Will try to figure out what!

Tks

"Ken Wright" wrote:

What takes so long? If you use a Pivot table and throw whatever field you
want to use to give you the individual sheets into the page fields, then
just display the Pivot table toolbar and use the show pages option and
choose that field. In about 3 seconds it will create all 40 sheets for you.

Regards
Ken..................

"Antonio" wrote in message
...
Hi, me again

Takes too long to do it manually, is there any "formula" to automate the
task??

Kind regards


"Ken Wright" wrote:

Yes - Pivot table with a dynamic data source. Wouldn't consider any
other
method for that many sheets (other than maybe VBA, but personally prefer
Pivots). Formulas will likely kill your workbook.

Regards
Ken.............................

"Antonio" wrote in message
...
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