Hi!

If there is some logic that can be put into a formula, then yes, this is
fairly easy.

In other words, why do you want 567 and 879 from sheet1 to "transfer" to
sheet6? What criteria do these values represent?

If you can build that type of logic into a formula then you can do this!

Biff

"rodante" wrote in
message ...

I hope I can get your help please. I want to know how to obtain
consecutive data from a sheet to another sheet in the same excel book.
I registered data in sheet one for different sheet in the book. I want
this data to b transferred automatically from sheet one to the
different sheets row sequency.

Example: Sheet one Row 23 567 to Sheet six Row 6 567
Sheet one Row 65 879 to Sheet six Row 7
879

As well data can be transferred to another sheets from Sheet one as
same fashion.

I hope there is some help for this problem.

Thanks


--
rodante
------------------------------------------------------------------------
rodante's Profile:
http://www.excelforum.com/member.php...o&userid=28251
View this thread: http://www.excelforum.com/showthread...hreadid=479998