Presume the source sheet is named: Misc.Parts
In the sheet: Summary,
Assume the various extracts are to be placed in row2 down
Let's use an empty col to the right, say col I, as the criteria col
Put in I2:
=IF(AND(ISNUMBER(Misc.Parts!A17),Misc.Parts!A170) ,ROWS($1:1),"")
Copy down to I201
Then, place
In A2:
=IF(ROWS($1:1)COUNT($I$2:$I$201),"",INDEX(Misc.Pa rts!A$17:A$216,SMALL($I$2:$I$201,ROWS($1:1))))
Copy A2 to B2, fill down to B201
In F2:
=IF(ROWS($1:1)COUNT($I$2:$I$201),"",INDEX(Misc.Pa rts!G$17:G$216,SMALL($I$2:$I$201,ROWS($1:1))))
Copy down to F201
In H2:
=IF(ROWS($1:1)COUNT($I$2:$I$201),"",INDEX(Misc.Pa rts!D$17:D$216,SMALL($I$2:$I$201,ROWS($1:1))))
Copy down to H201
The above set-up should return what you seek
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tina Hane" wrote:
I have a Summary worksheet that summarizes parts and labor entered on other
worksheets. One section should pull data from the Misc.Parts sheet. I would
like it to only pull data for lines that have a number 0 in cells A17:A216,
and populate the next blank line in the section. When the data populates, it
should pull from Col A on the old to Col A on the new, Col B to Col B, Col D
to Col H, and Col G to Col F. If there is not another blank line to use, it
should error or insert a blank line to be filled.
I have tried using some of the formulas in the posted questions, but nothing
even comes close. I would appreciate any assistance you can offer.