Hi,

I am new to vba and need help on below issue.

I have two sheets and want to copy data from one sheet to another where the data headers match. If there's a new column added in the first sheet then macro should copy all the matched data and give a msg box stating the name of the new field has been added and if a column which is required in the sheet 2 is not there in sheet 1 then the macro should stop stating that the sheet has been changed.

Is it possible? If yes then an early response will be highly appreciated as I am working on a project and it's kind of stuck because of this.

Regards,
Sorabh