How to copy one column into another sheet?

**excelgenius** · 11-16-2009, 10:10 AM

Hi,

As I am having difficulty using the search function, I need to ask this here.

How can I copy a column into another sheet with a macro?

"Copy column A of Sheet1 into column A of Sheet2"

Column A of Sheet1 is a range of data to be manually input. And when I press the macro button, I want it to be copied on column A of sheet2. I am sure this can be done, but how? Thanks, in advance.

**hannes001** · 11-16-2009, 10:23 AM

Please Login or Register  to view this content.

..where destinationRange might be Worksheets("Sheet2").columns("A") or something.

Hint: if forums search function is not working for you, then try Google, but add
"site:excelforum.com" into search query.

**excelgenius** · 11-16-2009, 10:33 AM

I used the code

Please Login or Register  to view this content.

and it worked as I needed. Thanks.

**parm1** · 11-18-2009, 07:35 AM

I'd like to do a similar thing, but need the data from the first sheet to copy onto a new row in the other sheet each time the button is clicked, any suggestions?

**broro183** · 11-18-2009, 08:51 AM

hi Parm1,

Can you please start a new thread with your question?
The Forum Rules state

2. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Rob