Hmmm....

I don't know!

If that's what they want, then why are they essentially transposing row 1
every othe cell?

Biff

"Max" wrote in message
...
"Biff" wrote:
...
Second, first time ever but the columns in first row in sheet 2 is
full, so I also need to continue same formula on the next sheet, sheet
3 but have it continue copying to same column on Sheet 2. How do i make
this possible?

Not following that!

Think the OP wants the formula to continue extracting from the first cell
in
next sheet, i.e. from Sheet3's B1:IV1, once the last, righmost cell within
Sheet2's B1:IV1 is exhausted. And to continue thereof in this fashion from
Sheet4's B1:IV1, Sheet5's B1:IV1, etc ...

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----