how to copy specific columns form one workbook to another

[amethystfeb]

Hi I have a code that copies a column data from one workbook to another workbook

Please Login or Register  to view this content.

This copies only D column to A coulmn of another workbook

I want 2 more columns to copied and pasted in another workbook


G column---- C Column
H column---- E Column

Any suggestions

[amethystfeb]

hi for now i tried this.. but the code looks clumpsy...opening n closing..

Please Login or Register  to view this content.

Can it be written in a better way