Copy dynamic range to a sheet in new workbook with specific format

[candeniz]

Cross Posted here: https://www.excelforum.com/excel-pr...orkbook-with-specific-format.html#post5077492

Hi,

You can see 2 sections in my attached excel file. Section-1 is the sheet in source workbook and Section-2 is the destination sheet to be copied in new workbook. I need a vba to copy the required data in a dynamic range from Section-1 (sheet1) to Section-2 (new sheet) with a specific format. The essentials are defined in attached file as well.

Thanks in advance for kindest helps.

Excel file can be downloaded from the link below

https://drive.google.com/file/d/1Fmh9tv75lPnfODVFyRblT_Japu0taBok/view?usp=sharing