Need code to process a table of data and segreate them month wise in a sheet

[Nitya0808]

Hello All,

There is a set of data in sheet 1.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Category[/TD]
[TD]Unit[/TD]
[TD]Period[/TD]
[TD]Data[/TD]
[TD]Lifecycle[/TD]
[/TR]
</tbody>[/TABLE]

There are 5 different units, and the categories can be similar or different across data. The data needs to categorized across units, per category, per period based on the lifecycle (only Active lifecycle is taken into calculation) in sheet 2.

I have a sample excel sheet. I will try to upload the same. For now, i have uploaded both the sheets as images

 

[Nitya0808]

Please ignore... Data posted at https://www.mrexcel.com/forum/excel-questions/1085566-data-processed-using-vb-macro.html#post5216731