• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy/paste columns from one workbook to a new one

S

snowman

New Member
Hi All,


This is my first post. I am also pretty new to VBA and excel.


I wonder if anybody can help me with a macro to copy&paste columns from one workbook to a new one. I did find some macros to do something similar. But I could not run them successfully.


Here is the table structure.


Column --- District fruit1 fruit2 fruit3 veg1 veg2 veg3 flower1...and so on.


There are more than 200 rows for each column.


I need to copy first, second, third and fourth column in one file; then first and fifth, sixth and seventh column in another file and so on. (columns 2, 3 & 4 have related data). (Columns A to DA and rows to 207 are populated.).


Could anyone please help me write a macro for this. Dont know how to start!.


Thanks in advance.
 
Before we start getting too far, I'd suggest checking out the example at Ron's page here:

http://www.rondebruin.nl/tips.htm

under the Copy/Paste/Merge section. He's got several excellent macros (or fully built add-ins) to handle various tasks. Perhaps one of them fits your situtation?


If not, I'd suggest uploading a workbook (doesn't have to be real data, a dummy file with correct structure would suffice) so we can help out. IF you need help on uploading a file, check out the green stickied thread at the top of the forum.
 
You must log in or register to reply here.
Back
Top