Vba excel macro - create pivot table and show selected details based on employee id

[amit81_ahl]

Hi

I have below dummy data and would like to create pivot table using vba macro. Mutiple users should be allowed to view data as per privilege given.

[FONT=&quot]1) Main data is always available with us[/FONT]
[FONT=&quot]2) Pivot table to prepared through macro. (same has been prepared without macro in the attached sheet)[/FONT]
[FONT=&quot]3) Unit Manager should be able to view details reporting RM's under him. E.g. Bharat should be able to view pivot table for Amit, Rajesh & Sumit. Same way for Karam & Param.[/FONT]
[FONT=&quot]4) Individual RM should be able to view his data only. For example : Amit should be able to view only his data. Similarly for Rajesh, Sumit, Jinu, Prabu.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]All mapping should be done based on Masterfile (Employee login ids).


[/FONT]

CIS NO	RM NO	RM NAME	Segment	Month End Balance(Non-investment)	Current Balance(Non-investment)	MTD Movement (Non-Investment)	Previous Month End Balance (Investment)	Current Balance (Investment)	MTD Movement (Investment)	Final CM Level Movement - Net Movement	Unit Manager
123456	12345	AMIT	PRIVATE	40,000.00	36,000.00	(4,000.00)	50,000.00	36,000.00	(14,000.00)	(18,000.00)	Bharat
123456	12345	AMIT	PRIVATE	43,000.00	39,000.00	(4,000.00)	52,000.00	39,000.00	(13,000.00)	(17,000.00)	Bharat
123456	12345	AMIT	PRIVATE	46,000.00	42,000.00	(4,000.00)	54,000.00	42,000.00	(12,000.00)	(16,000.00)	Bharat
123456	12345	AMIT	PRIVATE	49,000.00	45,000.00	(4,000.00)	56,000.00	45,000.00	(11,000.00)	(15,000.00)	Bharat
123457	12346	SUMIT	PRIVATE	51,000.00	47,000.00	(4,000.00)	58,000.00	47,000.00	(11,000.00)	(15,000.00)	Bharat
123457	12346	SUMIT	PRIVATE	53,000.00	49,000.00	(4,000.00)	60,000.00	49,000.00	(11,000.00)	(15,000.00)	Bharat
123457	12346	SUMIT	PRIVATE	55,000.00	51,000.00	(4,000.00)	62,000.00	51,000.00	(11,000.00)	(15,000.00)	Bharat
123457	12346	SUMIT	PRIVATE	57,000.00	53,000.00	(4,000.00)	64,000.00	53,000.00	(11,000.00)	(15,000.00)	Bharat
123458	12347	RAJESH	PRIVATE	59,000.00	55,000.00	(4,000.00)	66,000.00	55,000.00	(11,000.00)	(15,000.00)	Bharat
123458	12347	RAJESH	PRIVATE	61,000.00	57,000.00	(4,000.00)	68,000.00	57,000.00	(11,000.00)	(15,000.00)	Bharat
123458	12347	RAJESH	PRIVATE	63,000.00	59,000.00	(4,000.00)	70,000.00	59,000.00	(11,000.00)	(15,000.00)	Bharat
123458	12347	RAJESH	PRIVATE	65,000.00	61,000.00	(4,000.00)	72,000.00	61,000.00	(11,000.00)	(15,000.00)	Bharat
123459	12348	PRASAD	PRIVATE	67,000.00	63,000.00	(4,000.00)	71,000.00	63,000.00	(8,000.00)	(12,000.00)	Param
123459	12348	PRASAD	PRIVATE	69,000.00	70,000.00	1,000.00	70,000.00	70,000.00	-	1,000.00	Param
123459	12348	PRASAD	PRIVATE	71,000.00	72,000.00	1,000.00	69,000.00	72,000.00	3,000.00	4,000.00	Param
123459	12348	PRASAD	PRIVATE	73,000.00	74,000.00	1,000.00	68,000.00	74,000.00	6,000.00	7,000.00	Param
123459	12348	PRASAD	PRIVATE	75,000.00	76,000.00	1,000.00	67,000.00	76,000.00	9,000.00	10,000.00	Param
123460	12349	PRABU	PRIVATE	77,000.00	78,000.00	1,000.00	66,000.00	78,000.00	12,000.00	13,000.00	Param
123460	12349	PRABU	PRIVATE	79,000.00	80,000.00	1,000.00	65,000.00	80,000.00	15,000.00	16,000.00	Param
123460	12349	PRABU	PRIVATE	81,000.00	82,000.00	1,000.00	64,000.00	82,000.00	18,000.00	19,000.00	Param

<colgroup><col><col><col><col><col span="2"><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>