Getting rid of the blanks

[nick m]

Good evening all.
I have a spread sheet that opens another file, sort's data and searches for duplicate data. It then lists the duplicated data in another colum on another sheet. My problem is I cannot remember ( after late nights and some alchohol) how to get rid of the blanks to leave a polished report that is not full of holes. I am begining to unplug my pc ready for the window !
Pleae help I know it is a simple thing but i am tired.

 

[Aladin Akyurek]

On 2002-10-06 16:24, nick m wrote:
Good evening all.
I have a spread sheet that opens another file, sort's data and searches for duplicate data. It then lists the duplicated data in another colum on another sheet. My problem is I cannot remember ( after late nights and some alchohol) how to get rid of the blanks to leave a polished report that is not full of holes. I am begining to unplug my pc ready for the window !
Pleae help I know it is a simple thing but i am tired.

A macro would probably be more appropriate... but see my contrib with figures in:

http://www.mrexcel.com/board/viewtopic.php?topic=24204&forum=2&5

 

[Yogi Anand]

Hi nick m:

If I have understood you correctly, you now have a final list that has some blank rows in it. If this is the case, you can highlite the list (with blanks), then DATA|FILTER|AutoFilter -- Blanks ...

at this point only blank entries will show up -- you can delete these rows ...

and what remains is your original list with the blank rows deleted.

I hope this does it for you -- if not explain a little further and let us take it from there.

Regards!

Yogi
This message was edited by Yogi Anand on 2002-10-06 17:03

 

[nick m]

Thanks I will try that out in the morning

 

[nick m]

Thank Yogi I will try it out in the morning

Good night all