Perhaps you might want to try this play ..

Assume source data is in Sheet1, from row1 down

In an empty col to the right, say col Q?
Put in Q1: =IF(TRIM(P1)="Y",ROW(),"")
Copy Q1 down to say Q100, to cover the max expected data range

In another Sheet2
--------------------
Assuming you want to "transfer" the data into cols A and B

Put in A1:
=IF(ISERROR(SMALL(Sheet1!$Q:$Q,ROWS($A$1:A1))),"", INDEX(Sheet1!K:K,MATCH(SMA
LL(Sheet1!$Q:$Q,ROWS($A$1:A1)),Sheet1!$Q:$Q,0)))

Copy A1 across to B1, fill down to B100
(cover the same range as in col Q in Sheet1)

Cols A and B will return the desired results from cols K and L in Sheet1,
all bunched at the top (without any intervening blank rows)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"sari pratiwi via OfficeKB.com" wrote in message
...
i want to transfer the data from column K and L to another page based on
the answer on column P. If the answer is Y then the data from cell K11 and
L11 will transfer to another page, but if the answer is N then the data
wouldn't transfer. I tried them before, but I couldn't make them go in
order. because sometimes when the answer is N the data wouldn't transfer,
but when the answer for the next row is Y the data would transfer but it
would skip a row because the last row is N. So, how do I make them go in
order so they wouldn't skip a row? thanks

--
Message posted via http://www.officekb.com