copying multiple columns from one workbook to another workbook

[theprattipati]

copying multiple columns from one workbook to another workbook

 

[SunnyAlv]

copying multiple columns from one workbook to another workbook

can you provide an example of the data? and you want to use Excel Formula or VBA Excel

 

[theprattipati]

In My source sheet header name is "California", copy the data from California column and paste in destination sheet with header "Texas" like that I have multiple columns in both source and destination sheet