Pinkyhello
New Member
- Joined
- May 6, 2020
- Messages
- 10
- Office Version
- 2016
- Platform
- Windows
may i know Is there a way in multiple pivot table , to auto detect the area with data, because every month, the rows of data may differ by a few rows ,so at every year end i have to reset the data range so it can capture all the data.Thanks