Hi
I Have excel , in that we update reports on daily basis by adding new sheet
1. i want to combine all sheets in one consolidate master sheet
2, with that consolidated sheet, we want 2 pivot tabel based on criteria
3. so i want below button click function
1. button to Combine all sheet to one master sheet
2. button to Pivot Table1
3. button to Pivot Table2
4. i want Dynamic linked slicers to filter data
all above buttons should work dynamically whenever new data sheet added
' Here I upload sample file done all in manually' please help
▬▬▬▬▬▬▬▬▬ Mod edit : thread closed as duplicate !
I Have excel , in that we update reports on daily basis by adding new sheet
1. i want to combine all sheets in one consolidate master sheet
2, with that consolidated sheet, we want 2 pivot tabel based on criteria
3. so i want below button click function
1. button to Combine all sheet to one master sheet
2. button to Pivot Table1
3. button to Pivot Table2
4. i want Dynamic linked slicers to filter data
all above buttons should work dynamically whenever new data sheet added
' Here I upload sample file done all in manually' please help
▬▬▬▬▬▬▬▬▬ Mod edit : thread closed as duplicate !
original is in appropriate VBA Macros forum …