muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
i have 5 excel files with excatly same format but different count of rows (records). For each file contains 10 sheets.
but i have 1 sheet "master" into 10 sheets..
i want to make pivot table for multiple files above then connected from 5 files with sheet "master" as main table (pivot)
how to easy make it? How to do with easy step?
I'm blind about multiple table for pivot.
someone helping thank in advance..
susanto
i have 5 excel files with excatly same format but different count of rows (records). For each file contains 10 sheets.
but i have 1 sheet "master" into 10 sheets..
i want to make pivot table for multiple files above then connected from 5 files with sheet "master" as main table (pivot)
how to easy make it? How to do with easy step?
I'm blind about multiple table for pivot.
someone helping thank in advance..
susanto