Formula for Filter

[manjukhan]

I need to filter a column for non blanks and list the values on a different column. I can do this by doing a autofilter and filter for non blanks . But I want to do it automatically with a formula. Do any one have a formula accomplish this.

Thanks
Mansoor A Khan

[STEVE BELL]

Build code to do Advanced Filter with the criteria range >0

Do this manually with the recorder on, than edit the recorded code.

--
steveB

Remove "AYN" from email to respond
"manjukhan" <[email protected]> wrote in
message news:[email protected]...
>
> I need to filter a column for non blanks and list the values on a
> different column. I can do this by doing a autofilter and filter for
> non blanks . But I want to do it automatically with a formula. Do any
> one have a formula accomplish this.
>
> Thanks
> Mansoor A Khan
>
>
> --
> manjukhan
> ------------------------------------------------------------------------
> manjukhan's Profile:
> http://www.excelforum.com/member.php...o&userid=25268
> View this thread: http://www.excelforum.com/showthread...hreadid=387567
>