copy columns from 1 workbooks to another

[davecarrera]

Hi All

I have two workbooks and from workbook1(WB1) i would like to copy say columb A to columb C in workbook two(WB2), columb B in WB1 to columb F in WB2 and in columb G in WB2 enter a Y.

Also, just thought of this, in WB2 i need to clear the sheet from row A6 downwards before copying data from WB1.

I am very new to VBA so some kind gentle help is very much appreciated.

Kind Regards

Dave C

[royUK]

Do you want to copy to Row 6 ?

[royUK]

Try something like this

Please Login or Register  to view this content.