[RESOLVED] Macro should copy data from One sheet & paste in different format in another sheet

[ammu]

Dear All,

I am very new to VBA, hence I need your help to do this task.

Currently I have a sheet called "Sample_Raw_Data" where I have all raw details.

Now I want to copy and paste each row with below format in a different sheet

======================================================================================
Group Medium Subject State District City Sales SubRegion1 Fee Details Year Total Fees
======================================================================================

Can someone please let me know the VBA code to do this task?

I have attached sample excel file with sample results in the attachment.

Thank you so much for your help in advance

Best Regards
Amrutha