The macro recorder can be your friend. Record a macro while doing
datafilterautofilternon blankcopypaste
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"alex" wrote in message
...
hello everyone.

can someone give me a sample code that could scanned a column for
non-blank
cell of another worksheet and retrieve data to be entered to another
worksheet. honestly, i don't know how to make a macro but i've read it
could
be done with looping statement.

thanks