Would
Datafilterautofilternon blanks
help
if not
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"James" wrote in message
...
Hi all

I have a column with 1,000 rows but only 10 of the rows contain any data
and
they are spread out across the 1,000. On a seperate sheet I want to list
those 10 in a row together but I don't want to copy all 1,00 across and
use
data sort as it needs to be formula based.

Any ideas?!



--
James.