"Steve" wrote:
.. Is there any way on the list i can pull them to the top of the page.

One way to achieve it using non-array formulas

In the summary sheet,
Assume cols A to C will be the area for extracts from source sheet: Jan

Put in A2:
=IF(Jan!R2="","",ROW())
Leave A1 blank

Put in B2:
=IF(ROW(A1)COUNT($A:$A),"",INDEX(Jan!A:A,SMALL($A :$A,ROW(A1))))
Copy B2 to C2. Select A2:C2, copy down to cover the max expected extent of
source data. Hide away col A. Cols B and C will return the required results
from cols A and B in the source sheet: Jan, all neatly bunched at the top.
Repeat likewise the construct for extracts from the other months' (Feb, Mar
....) source sheets.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---