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