transfer data to sheet 2 conditionally

**esj001** · 10-26-2010, 01:13 PM

Im very new to excel and usually only work with pretty basic sum and date formulas----what i want to do is create a due list on sheet 2----if anything in column J on sheet one is a negative value----i want it to paste the row that contains the negative onto sheet 2---if this does not make sense i understand and can elaborate further if needed----

**NBVC** · 10-26-2010, 01:58 PM

In a new column in Sheet1, say at K2, enter formula:

=If(J2<0,Count(K$1:K1)+1,"")

and copy down

in L2 enter: =MAX(K:K)

then in Sheet2, A2 enter:

=IF(Rows($A$1:$A1)>'Sheet1'!$L$2,"",Index('Sheet1'!A:A,Match(Rows($A$1:$A1),'Sheet1'!$K:$K)))

and copy down as far as you want and across as far as you need to get all data.

adjust ranges and sheetnames to suit.

**esj001** · 10-27-2010, 01:57 PM

Thank you sir, Im sure that is the correct solution to my problem--but for the life of me I cant get it to work (im sure because of my ignorance)

Attached is a sample of the spreadsheet im working on (mine has many more rows of things)

----What I want to do is create a (this is due list) for airplane maintenance on Sheet2

----So everything in the Remaining hours column K that is < or equal to 0, needs to paste the entire row onto sheet2 in a list form

----so in my example rows 8 and 13 would paste over to sheet2 one right under the other, if that is possible

----------Thanks for any help that can be given to a newbie Exceler