Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
I'd apply Data|Filter|Autofilter to column P.
Then filter on column P to show just the y's. Then copy the visible cells in column K:L and paste to your other sheet. "sari pratiwi via OfficeKB.com" wrote: 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 -- Dave Peterson |
#3
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|