how to copy contents of one column to another column in another worksheet

should i use VBA to do this?
i need to copy the content of a column in one worksheet to another, if
the content in the cell is not empty. and when i add a macro, the sub
procedure ask me to pass in object, is it way like this:

sub copyAnswer(workbook, worksheet)
end sub

because the default one is
sub copyAnswer()
end sub

try

Sub copycol()
Sheets("sheet1").Columns("a").Copy _
Sheets("sheet2").Columns("a")
End Sub
--
Don Guillett
SalesAid Software
[email protected]
"yefei" <[email protected]> wrote in message
news:[email protected]...
> should i use VBA to do this?
> i need to copy the content of a column in one worksheet to another, if
> the content in the cell is not empty. and when i add a macro, the sub
> procedure ask me to pass in object, is it way like this:
>
> sub copyAnswer(workbook, worksheet)
> end sub
>
> because the default one is
> sub copyAnswer()
> end sub
>

thsnak very much
another issue
how to get rid of part of the text in a cell?
for example, if a cell contains "welcome", then i remoce it, and copy
the rest content of the cell to somewhere else.

Glad to help. Have a look at help indes for REPLACE and/or SUBSTITUTE

--
Don Guillett
SalesAid Software
[email protected]
"yefei" <[email protected]> wrote in message
news:[email protected]...
> thsnak very much
> another issue
> how to get rid of part of the text in a cell?
> for example, if a cell contains "welcome", then i remoce it, and copy
> the rest content of the cell to somewhere else.
>