Does the sample illustrate what you have in mind?

In the sample, in sheet: Summary, only lines from the source table (in
sheet: Input) where the key col A is filled (ie col A is not left blank)
would be pulled over, with all lines neatly bunched at the top.

Play with the sample. If you delete the entries in Input's col A, the
associated lines will disappear from Summary. Conversely, if you key-in
something into Input's col A, then the associated line(s) will appear in
Summary.

Summary's col A formulae act as criteria to flag arb row numbers for lines
in Input which are not blank. The other formulas in Summary's cols B to D
then reads the criteria col A's flags to return the associated lines from
Input, neatly packing all these lines at the top w/o any in-between blank
lines.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"thaenn" wrote:
Max:
I am somewhat confused by your formulas...
can you break it down (dumb it down) for me.
Thanks.