Hi Expert,

Currently I have a data sheet
1.png
There is 5 columns in the "Data" sheet.

I want to have a Macros to copy the data from "Data" sheet to "Report" sheet. It will follow my header in "Report" sheet to extract the data from "Data" Sheet
For example: "Report" Sheet with header Name and Subject, the Macro can extract the data in
Name Column from "Data" sheet to Name Column in "Report" sheet
Subject Column from "Data" sheet to Subject Column in "Report" sheet
2.png
Once I change the header in "Report" sheet, the Macro can copy the data from "Data" Sheet accordingly.

Marco Copy Data.xlsm

Thanks for your help!!!!