Copy Columns With Specific Headers and Paste Into Separate Workbook Based On Header

[mohanraj.610]

I need to copy contents from one excel if the sheet name matches based on mapping.

I need to copy contents of one excel into another if based on header.

I have sheet 1, 2 ,3 in excel1 and A, B, C in excel 2.

I need to copy this based on header mapping.

1-C
2-A
3-B

 

[YasserKhalil]

Can you attach you sample workbook?

 

[Marc L]

To copy columns from a worksheet to another one based on headers,

just use a single statement : AdvancedFilter ! See in VBA inner help …
​